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 41

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 42

True/False

Review LaterAdd Note

Review Later

A good relational DBMS excels at managing denormalized relations.

A) True
B) False

Correct Answer

verified

Show Answer

Question 43

Short Answer

Review LaterAdd Note

A dependency based on only a part of a composite primary key is called a(n) ____________________.

All relational tables satisfy the 1NF requirements.

A relational table must not contain ____________________ groups.

Dependency diagrams are very helpful in getting a bird's-eye view of all the relationships among a table's attributes.

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

Normalization represents a micro view of the entities within the ERD.

A table is in 2NF if it is in 1NF and it includes no partial dependencies.

Normalization should be part of the design process.

A table that displays data redundancies yields ____.

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

Normalization works through a series of stages called normal forms.

Unnormalized database tables often lead to various data redundancy disasters in production databases.

According to naming conventions described in Chapter 2, ____ would be the best name for a column representing the charges per hour in a table named JOB.

In ____________________, no row may contain two or more multivalued facts about an entity.

Normalization is a process that is used for changing attributes to entities.

When a nonkey attribute is the determinant of a key attribute the table is in 3NF but not ____________________.

Repeating groups must be eliminated by making sure that each row defines a single entity.

Describe a dependency diagram and explain its purpose.