If you have a many to many relationship between inventory and sale, where in the database tables should you record the attribute "quantity sold"?
A) After the Inventory Stock Number which is posted into the Sale table as a foreign key
B) Anywhere in the Inventory table
C) After the Invoice Number which is posted into the Inventory table as a foreign key
D) In a table that represents the relationship between Inventory and Sale (i.e. the Inventory-Sale table)
E) Anywhere in the Sale table

Question

Quizplus · Accepted Answer

In a many-to-many relationship, a junction table (or associative table) is used to store attributes that are specific to the relationship between the two entities, such as "quantity sold" in this case.

If You Have a Many to Many Relationship Between Inventory