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 21

True/False

Review LaterAdd Note

Review Later

Data stored at their highest level of granularity are said to be atomic data.

A) True
B) False

Correct Answer

verified

Show Answer

Question 22

Short Answer

Review LaterAdd Note

Review Later

The price paid for increased performance through denormalization is a larger amount of _____.

Correct Answer

verified

redundancy...

View Answer

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

A(n) _____ exists when there are functional dependencies such that Y is functionally dependent on X, Z is functionally dependent on Y, and X is the primary key.

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

It is possible for a table in 2NF to exhibit transitive dependency, where the primary key may rely on one or more nonprime attributes to functionally determine other nonprime attributes.

The combination of _____ and ER modeling yields a useful ERD, whose entities may now be translated into appropriate table structures.

In a real-world environment, changing granularity requirements might dictate changes in primary key selection, and those changes might ultimately require the use of _____ keys.

From a structural point of view, 3NF is better than _____.

All relational tables satisfy the _____ requirements.

The combination of normalization and ER modeling yields a useful ERD, whose entities can be translated into appropriate table structures.

A table that is in 2NF and contains no transitive dependencies is said to be in _____.

All relational tables satisfy the 1NF requirements.

According to the data-modeling checklist, _____ should be nouns that are familiar to business, should be short and meaningful, and should document abbreviations, synonyms, and aliases for each entity.

A dependency of one nonprime attribute on another nonprime attribute is a partial dependency.

When designing a new database structure based on the business requirements of the end users, the database designer will construct a data model using a technique such as _____.

When a table contains only one candidate key, _____ are considered to be equivalent.

Of the following normal forms, _____ is mostly of theoretical interest.

Normalization purity is often easy to sustain in the modern database environment.

BCNF can be violated only if the table contains more than one _____ key.

Since a partial dependency can exist only if a table's primary key is composed of several attributes, if a table in 1NF has a single-attribute primary key, then the table is automatically in 2NF.