Exam 6: Transforming Data Models Into Database Designs

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

What are MUST NOT and MUST COVER constraints?

In relational database design,ID-dependent entities are not used to ________.

For the M-O (parent mandatory,child optional)case,what action(s)should be taken to ensure minimum cardinality is maintained?

Referential integrity constraints should disallow adding a new row to a child table when the foreign key does not match a primary key value in the parent table.

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

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

In many-to-many relationships between strong entities in a relational database design,which of the following is not true?

To represent a 1:1 binary relationship in a relational database design,the key of one table is placed into the second table.

Which of the following is not true of MUST constraint?

The binary constraint must cover indicates that ________.

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

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.

A null value is an attribute value that has been set to zero.

When the key of one table is placed into a second table to represent a relationship,the key is called a relational key in the second table.

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

Each attribute of an entity becomes a(n)________ of a table.

A surrogate key should be considered when ________.

By default,the identifier of the entity becomes the foreign key of the corresponding table.

A surrogate key is a unique,system-supplied identifier used as the primary key of a table.