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 21

Multiple Choice

Review LaterAdd Note

Review Later

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

A) partial dependency
B) transitive dependency
C) repeating group
D) primary key

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

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

For most business transactional databases, we should normalize relations into ____.

A) 1NF
B) 2NF
C) 3NF
D) 6NF

E) B) and D)
F) All of the above

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

In order to meet ____________________ requirements, you may have to denormalize some portion of the database.

From a structural point of view, 2NF is better than ____.

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

Describe a dependency diagram and explain its purpose.

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

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

____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.

The ____________________ provides the big picture, or macro view, of an organization's data requirements and operations.

If database tables are treated as though they were files in a file system, the ____________________ never has a chance to demonstrate its superior data-handling capabilities.

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

Data redundancies occur from ____________________ of data on every row entry.

Denormalization produces a lower normal form.

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

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

In order to meet performance requirements, you may have to denormalize portions of the database design.

Granularity refers to ____.

A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key, is said to be in ____.

____ yields better performance.