90.9k views
4 votes
A table on the many side of a one-to-many or many-to-many relationship must:

(a) Be in second normal form (2NF)
(b) Be in third normal form (3NF)
(c) Have a single attribute key
(d) Have a composite key

1 Answer

3 votes

Final answer:

In a one-to-many or many-to-many relationship, the table on the many side must have a composite key.

Step-by-step explanation:

In a one-to-many or many-to-many relationship, the table on the many side must have a composite key. This is because the many side table contains multiple instances of the same related entity. A composite key is made up of two or more attributes that uniquely identify each record in the table. Having a composite key ensures that each record is uniquely identified and avoids duplicate data.

User Eduardo Sganzerla
by
8.2k points