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

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 22

Short Answer

Review LaterAdd Note

Review Later

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.

Correct Answer

verified

RDBMS
Relational Database Mana...

View Answer

Show Answer

Question 23

Short Answer

Review LaterAdd Note

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

Denormalization produces a lower normal form.

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

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.

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

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

Describe a dependency diagram and explain its purpose.

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.

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

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

Granularity refers to ____.

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

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

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

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

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

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