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 31

Multiple Choice

Review LaterAdd Note

Review Later

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

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

E) None of the above
F) A) and B)

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

Unnormalized tables yield no simple strategies for creating virtual tables known as _____.

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

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

In a(n) _____ diagram, the arrows above the attributes indicate all desirable dependencies.

Any attribute whose value determines other values within a row is known as a(n) _____.

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

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

From a system functionality point of view, _____ attribute values can be calculated when they are needed to write reports or invoices.

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

A table is in BCNF if every determinant in the table is a foreign key.

Normalization works through a series of stages called normal forms.

Granularity refers to _____.

In a _____ situation, one key determines multiple values of two other attributes and those attributes are independent of each other.

The _____ is central to a discussion of normalization.

Describe a dependency diagram and explain its purpose.

An attribute that is part of a key is known as a(n) _____ attribute.

Explain normalization and its different forms.

Dependencies based on only a part of a composite primary key are known as _____ dependencies.

Dependencies that are based on only a part of a composite primary key are called transitive dependencies.

If database tables are treated as though they were files in a file system, the _____ never has a chance to demonstrate its superior data-handling capabilities.