Questions tagged [many-to-many]

I'm working on creating a db model for the following requirements: I have many Types that have many different Statuses. Depending on the Type and Status, the Status can have certain SubStatuses. So let's say I have Type 1 with Status A, that has…

I was reading on this DBA page, about Student and Course relationship, and the use of a junction table. Suppose I wanted to do two things: Include the student grade for each course Allow the professor to generate an attendance sheet of students I…

I have the following case, which I can only describe as a chain of two many-to-many relationships: There are three business entities (tables) and two junction tables: Orders Products Features Orders has a many-to-many relation with Products through…