A binary one-to-many (1:N)relationship in an E-R diagram is represented by adding the primary key attribute (or attributes)of the entity on the one side of the relationship as a(n)________ in the relation that is on the many side of the relationship.
A)Primary key
B)Foreign key
C)Unique key
D)Index

Question

Quizplus · Accepted Answer

In a binary one-to-many relationship, the primary key attribute(s) of the entity on the one side becomes a foreign key attribute in the relation on the many side. This is done to maintain referential integrity between the two entities. Therefore, the best choice is B, which refers to a foreign key in the relation on the many side.

A Binary One-To-Many (1:N)relationship in an E-R Diagram Is Represented