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

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Crow's Foo...

View Answer

Show Answer

Question 22

Short Answer

Review LaterAdd Note

Review Later

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.

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

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.

All relational tables satisfy the _____ requirements.

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

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

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.

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.

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.

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

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

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

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

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

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

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

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

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

All relational tables satisfy the 1NF requirements.

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