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 41

Short Answer

Review LaterAdd Note

Review Later

An ERD is created through a(n) _____ process.

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

Some very specialized applications may require normalization beyond the _____.

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

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

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

To generate a surrogate key, Microsoft Access uses a(n) _____ data type.

In order to meet _____ requirements, you may have to denormalize some portions of a database design.

What characteristics do tables that conform to the concept of well-informed relations have?

The most likely data type for a surrogate key is _____.

Attribute A _____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.

Data warehouse routinely uses _____ structures in its complex, multilevel, multisource data environment.

It becomes difficult to create a suitable _____ key when the related table uses a composite primary key.

An attribute that cannot be further subdivided is said to display _____.

A table where all attributes are dependent on the primary key but are independent of each other, and no row contains two or more multivalued facts about an entity is said to be in _____.

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

An atomic attribute _____.

Improving _____ leads to more flexible queries.

Denormalization produces a lower normal form.