Exam 6: Normalization of Database Tables

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.

An attribute that is part of a key is known as a(n)____ attribute.

All relational tables satisfy the 1NF requirements.

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

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

Denormalization produces a lower normal form.

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

Any attribute that is at least part of a key is known as a(n)____________________.

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

Explain the BCNF.How is it related to other normal forms?

The combination of ____________________ and ER modeling yields a useful ERD,whose entities may now be translated into appropriate table structures.

Data redundancies occur from ____________________ of data on every row entry.

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.

A table where every determinant is a candidate key is said to be in ____.

Normalization works through a series of stages called normal forms.

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

Data redundancy produces ____.

Attribute A ____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.

Explain how database designers design and normalize databases.

Explain normalization and its different forms.