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
Correct Answer:
Verified
Q58: When using the sequential file organization,the addition
Q59: Combining all normalized user views into one
Q60: A data model that represents data in
Q61: The relation state specifying that nonprimary key
Q62: Which of the following statements is true
Q64: Which of the following properties of a
Q65: If order number serves as the primary
Q66: Each regular entity type in an E-R
Q67: Assume the structure of a relation is
Q68: For a unary one-to-one relationship between two
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