Exam 6: Transforming Data Models Into Database Designs

In many-to-many relationships in a relational database design,________.

In representing a 1:N relationship in a relational database design,the key of the table representing the entity on the "many" side is placed as a foreign key in the table representing the entity on the "one" side of the relationship.

Recursive M:N relationships are represented with an intersection table that shows pairs of related rows from a single table.

One of the important properties of an attribute is whether or not it is required.

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.

One of the important properties of a column is whether or not it can have a NULL value.

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

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

When the parent entity is required (M)in a relationship,every row of the child table must have a valid,non-null value of the foreign key.

The ideal primary key is ________.

To which of the following actions are referential integrity constraints not applied?

An entity needs to be examined according to normalization criteria before creating a table from it in the relational database design.

Explain the pragmatic reason for using surrogate keys.

What are the four sets of minimum cardinalities that can be present in a 1:N binary relationship?

A foreign key is a key that does not belong in any table.

When transforming an E-R data model into a relational database design,the key of the parent entity should be placed as part of the primary key into the child entity ________.

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

A referential integrity constraint policy that insures that foreign key values in a table are correctly maintained when there is a change to the primary key value in the parent table is called ________.

When creating a table in the relational database design from an entity in the extended E-R model,the attributes of the entity become the rows of the table.

When transforming supertype/subtype entities into a relational database design,the key of the supertype table is placed into the subtype table typically as the key.