Exam 3: The Relational Model and Normalization

The only reason(s)for having relations is to ________.

A relation is in Boyce-Codd Normal Form (BCNF)if and only if it is in 3NF and every determinant is a candidate key.

A primary key is a candidate key that has been selected to uniquely identify rows in a relation.

A key consisting of one or more columns that is a primary key in another relation is a ________.

Explain the concept of a foreign key.

Briefly describe the various tasks of the primary key.

Which of the following is true about the functional dependency (A,B)→ (C,D)?

Distinguish between the primary key and a candidate key.

Normalization is a process used to deal with which of the following modification anomalies?

When designing or normalizing relations,each relation should have only one theme.

If by knowing the value of A we can find the value of B,then we would say that B is functionally dependent on A.

Explain the relationships among primary keys and functional dependencies.

A relation is in 2NF if and only if it is in 1NF and all non-key attributes are determined by the entire primary key.

Describe the requirements that a table must meet to qualify as a relation.

A combination key is a group of attributes that uniquely identifies a row.

Candidate keys are called interlocking candidate keys when they share one or more attributes.

A determinant that determines all the other columns in a relation is a ________.

An attribute is considered to be a non-key attribute when it is a non-prime attribute,which means that the attribute is not contained in any candidate key.

The columns of a relation are sometimes called tuples.

A tuple is a group of one or more columns that uniquely identifies a row.