In a "one-to-many" relationship,which constraint is usually added to the "many" table?
A) UNIQUE
B) PRIMARY KEY
C) FOREIGN KEY
D) NOT NULL

Question

In a "one-to-many" relationship,which constraint is usually added to the "many" table?​
A) ​UNIQUE
B) ​PRIMARY KEY
C) ​FOREIGN KEY
D) ​NOT NULL

Quizplus · Accepted Answer

In a "one-to-many" relationship, the constraint that is usually added to the "many" table is a FOREIGN KEY. This is because the "many" table will contain a foreign key that references the primary key of the "one" table, establishing the relationship between the two tables. The foreign key constraint ensures that only valid references are allowed in the "many" table. UNIQUE, PRIMARY KEY, and NOT NULL constraints may also be added, but they are not specifically related to enforcing the "one-to-many" relationship.

In a "One-To-Many" Relationship,which Constraint Is Usually Added to the "Many