Exam 6: Normalization of Database Tables

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

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

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

A(n)____________________ derives its name from the fact that a group of multiple entries of the same type can exist for any single key attribute occurrence.

According to the Data-Modeling Checklist,____________________ should be nouns that are familiar to business and should be short and meaningful,and should document abbreviations,synonyms,and aliases for each entity.

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

Explain how database designers design and normalize databases.

All relational tables satisfy the ____________________ requirements.

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

Any attribute whose value determines other values within a row is called a(n)____________________.

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

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.

Some very specialized applications may require normalization beyond the ____.

A dependency based on only a part of a composite primary key is called a(n)____________________.

Denormalization produces a lower normal form.

A table that displays data redundancies yields ____.

A table where all attributes are dependent on the primary key and are independent of each other,and no row contains two or more multivalued facts about an entity,is said to be in ____.

1NF,2NF,and 3NF are ____.

With partial dependencies,data redundancies occur because every row entry requires duplication of data.

Data redundancy produces ____.