Exam 3: The Relational Model and Normalization

In general,each relation should have ________.

Relations are classified into normal forms based on the types of modification anomalies that they are vulnerable to.

A combination of one or more columns used to identify particular rows in a relation is a ________.

Surrogate keys usually slow performance.

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.

A referential integrity constraint limits the values of a foreign key.

A key is a combination of one or more columns that is used to identify particular rows in a relation.

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

A relation is a table that has special restrictions on it.

A deletion anomaly exists when deleting data about one entity results in the loss of data about another entity.

If a table meets the minimum definition of a relation,it has an effective or appropriate structure.

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.

A surrogate key is an artificial column that is added to a relation to be its primary key.

A relation is also known as a(n)________.

A referential integrity constraint is used to make sure the values of a foreign key match a valid value of a primary key.

Any table that meets the definition of a relation is said to be in first normal form (1NF).

A multivalued dependency exists when a determinant is matched to a set of values.

A table that meets the definition of a relation is in ________.

A functional dependency is a relationship between attributes such that if we know the value of one attribute,we can determine the value of the other attribute.

A constraint that requires an instance of an entity to exist in one relation before it can be referenced in another relation is called an insertion anomaly.