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 41

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 42

True/False

Review LaterAdd Note

Review Later

Normalization is a very important database design ingredient and the highest level is always the most desirable.

A) True
B) False

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

A table that is in 1NF and includes no partial dependencies is said to be in ____.

Repeating groups must be eliminated by making sure that each column defines a single entity.

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

Granularity refers to ____.

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

A table where all attributes are dependent on the primary key and are independent of each other,and no row contains two or more multivalued facts about an entity,is said to be in ____.

Normalization should be part of the design process.

Normalization produces a lower normal form.

Converting a database format from 1NF to 2NF is a complex process.

It is possible for a table in 2NF to exhibit transitive dependency,where one or more nonprime attributes functionally determine other nonprime attributes.

All relational tables satisfy the ____________________ requirements.

What steps are involved in the conversion to third normal form?

In order to meet ___________________ requirements,you may have to denormalize some portion of the database.

If a table has multiple candidate keys and one of those candidate keys is a composite key,the table can have ____ based on this composite candidate key,even when the primary key chosen is a single attribute.

Normalization purity is easy to sustain in the modern database environment.

For most business transactional databases,we should normalize relations into ____.

Most designers consider the BCNF as a special case of the ____.

A table that displays data redundancies yields ____.