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

Multiple Choice

Review LaterAdd Note

Review Later

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

A) character
B) sequence
C) AutoNumber
D) identity

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

Correct Answer

verified

Show Answer

Question 42

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

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

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

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.

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

Improving _____ leads to more flexible queries.

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

Denormalization produces a lower normal form.

An atomic attribute _____.

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

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

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

Some very specialized applications may require normalization beyond the _____.

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