CSIT 154 Practice Quiz 5

To generate a surrogate key, Microsoft Access uses a(n) _____ data type.

AutoNumber

When a nonkey attribute is the determinant of a key attribute, the table is in 3NF but not in _____.

BCNF

Of the following normal forms, _____ is mostly of theoretical interest.

DKNF

A good relational DBMS excels at managing denormalized relations.

False

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

False

In the context of partial dependencies, data redundancies occur because every row entry requires duplication of data.

True

Repeating groups must be eliminated by ensuring that each row defines a single entity.

True

The objective of normalization is to ensure that each table conforms to the concept of well-formed relations.

True

Unnormalized database tables often lead to various data redundancy disasters in production databases.

True

The _____ is central to a discussion of normalization.

concept of keys

Data redundancy produces _____.

data integrity problems

_____ refers to the level of detail represented by the values stored in a table's row.

granularity

The most likely data type for a surrogate key is _____.

numeric

Dependencies based on only a part of a composite primary key are known as _____ dependencies.

partial

When a table contains only one candidate key, _____ are considered to be equivalent.

the 3NF and the BCNF