FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: Normalization of Database Tables

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Essay

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Step 1: Make New Tables to Eliminate Tra...

View Answer

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 3

Short Answer

Review LaterAdd Note

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

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.

Explain the Boyce-Codd normal form (BCNF). How is it related to other normal forms?

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

Normalization works through a series of stages called normal forms. For most purposes in business database design, _____ stages are as high as you need to go in the normalization process.

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

A table is in 4NF if it is in 3NF, and _____.

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

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

Because a partial dependency can exist only when a table's primary key is composed of several attributes, a table whose _____ key consists of only a single attribute is automatically in 2NF once it is in 1NF.

In order to meet performance requirements, portions of the database design may need to be occasionally denormalized.

A relational table must not contain a(n) _____.

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 are stored in the table as rows.

A _____ derives its name from the fact that a collection of multiple entries of the same type can exist for any single key attribute occurrence.

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

In a real-world environment, we must strike a balance between design integrity and _____.

A table is in fourth normal form if it is in third normal form and has no independent multivalued dependencies.

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