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

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

A) important
B) nonprime
C) prime
D) entity

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

Correct Answer

verified

Show Answer

Question 22

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 D)
F) A) and C)

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

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

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

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

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

Denormalization produces a lower normal form.

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?

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

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

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.

Describe a dependency diagram and explain its purpose.

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

____ yields better performance.

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

Granularity refers to ____.

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

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

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