Exam 6: Normalization of Database Tables

An attribute that cannot be further subdivided is said to display .

A derives its name from the fact that a collection of multiple entries of the same type can exist for any single key attribute occurrence.

Explain the Boyce-Codd normal form (BCNF). How is it related to other normal forms?

A determinant is any attribute whose value determines other values within a column.

Normalization is a process that is used for changing attributes to entities.

From a system functionality point of view, attribute values can be calculated when they are needed to write reports or invoices.

Relational models view data as part of a table or collection of tables in which all key values must be identified.

Denormalization produces a lower normal form.

A table that is in 2NF and contains no transitive dependencies is said to be in .

Attributes should clearly define participation, connectivity, and document cardinality.

The advantage of higher processing speed must be carefully weighed against the disadvantage of data anomalies.

A(n) exists when there are functional dependencies such that Y is functionally dependent on X, Z is functionally dependent on Y, and X is the primary key.

A table is in BCNF if every determinant in the table is a foreign key.

In a situation, one key determines multiple values of two other attributes and those attributes are independent of each other.

A dependency based on only a part of a composite primary key is known as a partial dependency.

A good relational DBMS excels at managing denormalized relations.

Unnormalized tables yield no simple strategies for creating virtual tables known as .

Normalization produces a lower normal form.

In a real-world environment, we must strike a balance between design integrity and .

An atomic attribute .