Multiple Choice
When transforming an ID-dependent E-R data model relationship into a relational database design and the child entity is designed to use a surrogate key,then ________.
A) the parent entity must also use a surrogate key
B) the relationship remains an ID-dependent relationship
C) the relationship changes to a non-ID-dependent relationship
D) A and B
E) A and C
Correct Answer:
Verified
Correct Answer:
Verified
Q7: When transforming an extended E-R model into
Q22: In a 1:N relationship,the term parent refers
Q24: Cascading deletions are generally not used with
Q31: Explain the representation of a one-to-many strong
Q47: When transforming supertype/subtype entities into a relational
Q55: The first step in transforming an extended
Q60: Which of the following is not true
Q61: A referential integrity constraint policy that guarantees
Q62: Write the schema to represent the entities
Q78: It is easy to enforce the referential