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

is a process to help reduce the likelihood of data anomalies.

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

Most designers consider the BCNF as a special case of the .

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

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

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

A table is in fourth normal form if it is in third normal form and has no independent multivalued dependencies.

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

yields better performance.

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.

A relational table must not contain a(n) .

Data redundancy produces data anomalies.

A dependency based on only a part of a composite primary key is called a .

The objective of normalization is to ensure that each table conforms to the concept of well-formed relations.

The problem with transitive dependencies is that they still yield data .

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

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

Normalization is a very important database design ingredient, and the highest level is always the most desirable.

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

A(n) exists when there are functional dependencies such that XY is functionally dependent on WZ, X is functionally dependent on W, and XY is the primary key.

Dependencies can be identified with the help of a dependency .

Atomic attributes are attributes that can be further subdivided.

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

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