Exam 9: Normalizing Database Designs

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

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

All relational tables satisfy the ____________________ requirements.

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

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

Explain how database designers design and normalize databases.

Normalization works through a series of stages called ____________________ forms.

It becomes difficult to create a suitable ____________________ key when the related table uses a composite primary key.

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

An attribute that cannot be further divided is said to display ____________________.

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.

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

Improving ____ leads to more flexible queries.

Converting a database format from 1NF to 2NF is a complex process.

An atomic attribute ____.

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.

If you have three different transitive dependencies, ____ different determinant(s) exist.

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

An example of denormalization is using a ____ denormalized table to hold report data. This is required when creating a tabular report in which the columns represent data that is stored in the table as rows.

Most designers consider the BCNF as a special case of the ____.