Podcast
Questions and Answers
Any nonkey attributes that are associated with the M:N relationship are included with the relation ______.
Any nonkey attributes that are associated with the M:N relationship are included with the relation ______.
C
When mapping binary one-to-one relationships, a foreign key is included in the relation on the ______ side of the relationship.
When mapping binary one-to-one relationships, a foreign key is included in the relation on the ______ side of the relationship.
optional
When mapping associative entities, a third relation is created for the ______ entity.
When mapping associative entities, a third relation is created for the ______ entity.
associative
The default primary key of the associative relation consists of the ______ key that combines the two primary key attributes from the other two relations.
The default primary key of the associative relation consists of the ______ key that combines the two primary key attributes from the other two relations.
Signup and view all the answers
In some cases, additional attributes are required to form a unique ______ in a ternary relationship.
In some cases, additional attributes are required to form a unique ______ in a ternary relationship.
Signup and view all the answers
In Step 3 of database design, binary one-to-one relationships are mapped by creating ______ relations.
In Step 3 of database design, binary one-to-one relationships are mapped by creating ______ relations.
Signup and view all the answers
When mapping ternary relationships, a new ______ relation is created.
When mapping ternary relationships, a new ______ relation is created.
Signup and view all the answers
The primary key of the associative relation in a ternary relationship consists of the ______ primary key attributes from the participating entity types.
The primary key of the associative relation in a ternary relationship consists of the ______ primary key attributes from the participating entity types.
Signup and view all the answers
In Step 4 of database design, associative entities with assigned identifiers are mapped by creating ______ relations.
In Step 4 of database design, associative entities with assigned identifiers are mapped by creating ______ relations.
Signup and view all the answers
In a relational database, the primary key of a relation is used as a foreign key in another relation to establish a ______ relationship.
In a relational database, the primary key of a relation is used as a foreign key in another relation to establish a ______ relationship.
Signup and view all the answers
