When mapping a supertype/subtype relationship which of the following i – McqOptions

MCQOPTIONS

1.	When mapping a supertype/subtype relationship which of the following is true?
A.	The supertype primary key is assigned to each subtype.
B.	The subtype primary key is assigned to each supertype.
C.	There is no link between the supertype/subtype entities.
D.	There is no primary key/foreign key relationship between a supertype/subtype.
Answer» B. The subtype primary key is assigned to each supertype.

Discussion

No Comment Found

Related MCQs

In a 1:M relationship, the primary key on the one side migrates to the many side to become the foreign key on the many side.
If a relation is in third normal form, it does not need to be in second normal form.
A synonym is two or more attributes that have different names but the same meaning.
Normalization is a formal process for deciding which attributes should be grouped together in a relation.
The primary key in a relation does not need to be underlined.
The primary key of the new relation in a many-to-many relationship is a composite key comprised of the primary keys of each of the binary entities.
A foreign key may be null and still adhere to the referential integrity constraint.
Well-structured relations encourage anomalies of data.
When mapping a binary many-to-many relationship into a relation which of the following is true?
If no multivalued attributes exist in a relation, then the relation is in what normal form?