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.
Correct Answer:
Verified
Q95: Given a FACULTY relation that includes both
Q96: The relation state specifying that nonprimary key
Q97: The dependence of nonprimary key attributes on
Q98: For a binary many-to-many relationship existing between
Q99: Another name for a unary relationship is
Q101: Referencing use-case modeling, a source is an
Q102: The object-oriented systems development life cycle progressively
Q103: A use case is used to represent
Q104: On a use-case diagram, an actor is
Q105: The Unified Modeling Language (UML) is a
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents