A Binary One-To-Many Relationship in an E-R Diagram Is Best

Multiple Choice

A binary one-to-many relationship in an E-R diagram is best represented by:

A) the creation of a separate relation; the primary key of this new relation is a composite key consisting of the primary key for each of the two entities in the relationship.
B) adding the primary key attribute (or attributes) of the entity on the one side of the relationship as a foreign key in the relation that is on the many side of the relationship.
C) adding the primary key attribute (or attributes) of the entity on the many side of the relationship as a foreign key in the relation that is on the one side of the relationship.
D) creating a relation with a composite primary key and nonkey attributes.
E) none of the above.