FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 9: Normalizing Database Designs

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Multiple Choice

Review LaterAdd Note

Review Later

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.

A) Boyce-Codd Normal Form
B) redundancy
C) time-variance
D) partial dependencies

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

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

When designing a database, you should ____.

A) make sure entities are in normal form before table structures are created
B) create table structures then normalize the database
C) only normalize the database when performance problems occur
D) consider more important issues such as performance before normalizing

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

Correct Answer

verified

Show Answer

Question 53

True/False

Review LaterAdd Note

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

The problem with transitive dependencies is that they still yield data ____________________.

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

A table that is in 1NF and includes no partial dependencies is said to be in ____.

A diagram that depicts all dependencies found within a given table structure is known as a(n) ____________________.

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

Of the following normal forms, ____ is mostly of theoretical interest.

____________________ is a process to help reduce the likelihood of data anomalies.

Normalization is a very important database design ingredient and the highest level is always the most desirable.

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 table is in fourth normal form if it is in third normal form and has no independent multivalued dependencies.

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

A table is in 4NF if it is in 3NF and ____.

Explain normalization and its different forms.

The price paid for increased performance through denormalization is a larger amount of ____________________.

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 ____.

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

Atomic attributes are attributes that can be further subdivided.