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

To generate a surrogate key,Microsoft Access uses a(n) ____ data type.

A) surrogate
B) sequence
C) AutoNumber
D) identity

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

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

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

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

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

Before converting a table into 3NF,it is imperative the table already be in ____.

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 a real-world environment,we must strike a balance between design integrity and ____.

Improving ____ leads to more flexible queries.

Of the following normal forms,____,is mostly of theoretical interest.

Normalization works through a series of stages called ___________________ forms.

With parrtial dependencies,data redundancies occur because every row entry requires duplication of data.

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

The combination of normalization and ER modeling yields a useful ERD,whose entities may now be translated into appropriate relationship structures.

____ yields better performance.

An attribute that cannot be further divided is said to display ____________________.

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

A table that is in 2NF and contains no transitive dependencies is said to be in ____.

In order to meet performance requirements,you may have to denormalize portions of the database design.

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