Exam 6: Transforming Data Models Into Database Designs

Association tables sometimes connect more than two entities.

Data types are consistent across all DBMS products.

To represent an M:N relationship in a relational database design,in essence it is reduced to two 1:N relationships.

The ideal primary key is ________.

When the child entity is required (M)in a relationship,there needs to be at least one child row for each parent row at all times.

The binary constraint MUST NOT indicates that ________.

When transforming supertype/subtype entities into a relational database design,an entity is created for the supertype only.

Write the schema to represent the entities below,including tables,the proper placement of the foreign key,and referential integrity constraint.

If the parent is required,then a new child row must be created with a valid foreign key value.

The key of an intersection table is always the combination of the keys of both parents.

In 1:N relationships,the table on the "many" side is called the child.

When creating a relational database design from E-R diagrams,first create a relation for each relationship.

In a relational database design,all relationships are expressed by creating a foreign key.

A default value is the value the user enters into the row the first time the user enters data.

Explain the representation of a one-to-many strong entity relationship in a relational database design.

An intersection table is always ID-dependent on both of its parent tables.

To represent an M:N relationship in a relational database design,an intersection table is created.

In 1:N relationships,the table on the "one" side is called the parent.

When representing a one-to-many relationship in a relational database design ________.

Cascading deletions are generally not used with relationships for weak child entities.