Multiple Choice
Which of the following is a specialization hierarchy disjoint constraint scenario in case of partial completeness?
A) Subtype discriminator can be null.
B) Subtype discriminator cannot be null.
C) Each supertype occurrence is a member of only one subtype.
D) Each supertype occurrence is a member of at least one subtype.
Correct Answer:
Verified
Correct Answer:
Verified
Q13: While using a surrogate key, one must
Q14: In which two cases are composite primary
Q15: Composite keys are useful as identifiers of
Q16: An entity supertype can have disjoint or
Q17: Within a specialization hierarchy, a supertype can
Q19: _ keys work with primary keys to
Q20: The property of _ enables an entity
Q21: Explain the two criteria that help a
Q22: _ completeness means that not every supertype
Q23: A _ is a primary key created