FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Database Design 1: Normalization

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

True/False

Review LaterAdd Note

Review Later

Converting to third normal form always avoids the problems related to dependencies.

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

The conversion of an unnormalized table to first normal form requires the removal of ____.

A) determinants
B) interrelation constraints
C) nonkey columns
D) repeating groups

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

In general,when converting a non-first normal form table to first normal form,the primary key will usually include the original primary key concatenated with the key to the repeating group.

By splitting relations to achieve third normal form tables,you create the need to express interrelation constraints.

The primary key in a table is a determinant but candidate keys are not determinants.

What are the four categories of update anomalies and why could these problems occur when a relation is in first normal form but not in second normal form?

Functional dependencies can be determined by looking at sample data.

To correct update anomalies in a database,tables must be converted into various types of normal forms.

By splitting relations to achieve third normal form tables,you create the need to express a(n) ____________________ constraint,a condition that involves two or more relations.

What is the difference between a table in second normal form and one in third normal form?

From all the ____ keys,one is chosen to be the primary key.

Partial dependencies are dependencies on only a portion of the ____.

Tables that are in second normal form do not update anomalies.

Another name for a nonkey column is a ____.

A table is in fourth normal form when it is in third normal form and there are no ____.

If there is more than one possible choice for the primary key,and one of the possibilities is chosen to be the primary key,the other choices are referred to as ____.

In a dependency diagram,the arrows below the boxes indicate the partial dependencies.

If B (an attribute) is functionally dependent on A,we can also say that ____.

If B is functionally dependent on A,you can also say that B functionally determines A.

____________________ dependencies are dependencies on only a portion of the primary key.