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

Multiple Choice

Review LaterAdd Note

Review Later

Normalization works through a series of stages called normal forms.For most purposes in business database design,____ stages are as high as you need to go in the normalization process.

A) two
B) three
C) four
D) five

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

1NF,2NF,and 3NF are ____.

A) normalization stages
B) anomalies
C) repeating groups
D) atomic attributes

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

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

Any attribute whose value determines other values within a row is called a(n)____________________.

Some very specialized applications may require normalization beyond the ____.

The ____________________ provides the big picture,or macro view,of an organization's data requirements and operations.

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

A diagram that depicts all dependencies found within a given table structure is known as a(n)____________________.

A good relational DBMS excels at managing denormalized relations.

An example of denormalization is using a ____ denormalized table to hold report data.This is required when creating a tabular report in which the columns represent data that is stored in the table as rows.

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

It becomes difficult to create a suitable ____________________ key when the related table uses a composite primary key.

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

Because a partial dependency can exist only if a table's primary key is composed of several attributes,a table whose ____________________ key consists of only a single attribute is automatically in 2NF if it is in 1NF.

Relational models view the data as part of a table or collection of tables in which all key values must be identified.

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

A ____ exists when there are functional dependencies such that Y is functionally dependent on X and Z is functionally dependent on Y,and X is the primary key.

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

Atomic attributes are attributes that can be further divided.

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

An atomic attribute ____.