CHAPTER 6

Which of the following is not a step in the database design process?

Create constraints and triggers

An intersection table can have additional attributes besides the keys of its parent tables.

FALSE

The design transformation for all IS-A relationships can be summarized by the phrase "place the key of the parent table in the child table."

FALSE

Which of the following is not true of MUST constraint?

It can be expressed directly in a relational model.

Many-to-many relationships are represented by ________.

an intersection table which has 1:N relationships with the two tables

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

column

In a relational database design, all relationships are expressed by ________.

creating a foreign key

To represent a one-to-many relationship in a relational database design, ________.

the key of the parent is placed as a foreign key into the child

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

the parent is always on the one side of the "one-to-many" relationship

A referential integrity constraint policy that guarantees that a row in a parent table always has a required entry in a child table ________.

Both is known as a minimum cardinality enforcement action and needs to be documented by the database development team are correct

A referential integrity constraint policy that insures that all rows containing a particular foreign key value in a table are eliminated from the table when the row containing the corresponding primary key value in a parent table is eliminated from the database is called cascading deletes.

TRUE

Cascading deletions are generally not used with relationships between strong entities.

TRUE

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

TRUE

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

TRUE

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.

TRUE

The last step in creating a table is to verify table normalization.

TRUE

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

TRUE

A surrogate key should be considered when

The key contains a lengthy text field