Exam 6: Normalization of Database Tables

A diagram that depicts all dependencies found within a given table structure is known as a(n)____________________.

Normalization represents a micro view of the ____ within the ERD.

The price paid for increased performance through denormalization is a larger amount of ___________________.

If a table has multiple candidate keys and one of those candidate keys is a composite key,the table can have ____ based on this composite candidate key,even when the primary key chosen is a single attribute.

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

If database tables are treated as though they were files in a file system,the _________________________ never has a chance to demonstrate its superior data-handling capabilities.

Atomic attributes are attributes that can be further divided.

Normalization works through a series of stages called ___________________ forms.

A table is in 2NF if it is in 1NF and it includes no partial dependencies.

It is possible for a table in 2NF to exhibit transitive dependency,where one or more nonprime attributes functionally determine other nonprime attributes.

Normalization is a very important database design ingredient and the highest level is always the most desirable.

In a real-world environment,changing granularity requirements might dictate changes in primary key selection,and those changes might ultimately require the use of ____________________ keys.

Dependencies based on only a part of a composite primary key are called ____ dependencies.

For most business transactional databases,we should normalize relations into ____.

A table that has all key attributes defined,has no repeating groups,and all its attributes are dependent on the primary key,is said to be in ____.

Normalization represents a micro view of the entities within the ERD.

Dependencies can be identified with the help of a dependency ____________________.

Dependency diagrams are very helpful in getting a bird's-eye view of all the relationships among a table's attributes.

What steps are involved in the conversion to third normal form?

____ yields better performance.