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

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

The most likely data type for a surrogate key is .

A) character
B) date
C) logical
D) numeric

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

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

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

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

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.

Improving leads to more flexible queries.

In order to meet performance requirements,portions of the database design may need to be occasionally denormalized.

In the context of partial dependencies,data redundancies occur because every row entry requires duplication of data.

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

The is central to a discussion of normalization.

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

A table where every determinant is a candidate key is said to be in .

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

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

Normalization represents a micro view of the entities within the ERD.

Data warehouse routinely uses structures in its complex,multilevel,multisource data environment.

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

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

The advantage of higher processing speed must be carefully weighed against the disadvantage of data anomalies.

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