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

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

Correct Answer

verified

A table is in Boyce-Codd normal form (BC...

View Answer

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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

A) entity
B) attribute
C) relationship
D) repeating group

E) A) and B)
F) C) and D)

Correct Answer

verified

Show Answer

Question 3

Essay

Review LaterAdd Note

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

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

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

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.

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

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

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) _____.

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.

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

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

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

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

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.

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.

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

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

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.