Chapter 4

A candidate key is an attribute, or combination of attributes, that uniquely identifies a row in a relation.

A cascading delete removes all records in other tables associated with the record to be deleted.

A constraint between two attributes is called a(n):

A referential integrity constraint is a rule that maintains consistency among the rows of two relations.

A functional dependency between two or more nonkey attributes is called a:

A primary key is an attribute that uniquely identifies each row in a relation.

A primary key that consists of more than one attribute is called a:

A primary key whose value is unique across all relations is called a(n):

A relation is in first normal form if it has no more than one multivalued attribute.

A relation that contains no multivalued attributes and has nonkey attributes solely dependent on the primary key but contains transitive dependencies is in which normal form?

A rule that states that each foreign key value must match a primary key value in the other relation is called the:

A two-dimensional table of data sometimes is called a:

All of the following are the main goals of normalization EXCEPT:

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:

An attribute (or attributes) that uniquely identifies each row in a relation is called a:

In the figure below, the primary key for "Order Line" is which type of key?

In the figure below, what type of relationship do the relations depict?

The allowable range of values for a given attribute is part of the domain constraint.

The columns of a relation can be interchanged without changing the meaning or use of the relation.

The normal form which deals with multivalued dependencies is called: