Which of the following situation requires the use of ID-dependent entities?

The identifier of an entity will become the ________ of the new table.

A foreign key is:

Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?

Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?

The DBMS allows surrogate keys to be changed.

(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.

When the parent entity is required, a new child row can always be inserted.

A foreign key is used to implement relationships between tables.

Which of the following columns is(are) are required in a table?

A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):

In a 1:N relationship, the foreign key is placed in:

Cascading updates refers to child rows being automatically deleted when a parent row is deleted.

When transforming an entity-relationship model into a relational database design, each entity is represented as a table.

When the parent entity is required and the parent has a surrogate key, update actions can be ignored.

When the parent entity is required, a new parent row can always be inserted.

All primary keys are required.

The terms alternate key and candidate key mean the same thing.

In 1:N relationships, which entity becomes the parent entity is arbitrary.

In a 1:1 relationship, the foreign key is placed in: