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 1

Short Answer

Review LaterAdd Note

Review Later

An ERD is created through an process.

Correct Answer

verified

Show Answer

Question 2

Short Answer

Review LaterAdd Note

Review Later

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.

Correct Answer

verified

RDBMS
relational database mana...

View Answer

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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

An attribute that is part of a key is known as a(n) attribute.

Granularity refers to .

Reporting anomalies in a table can cause a multitude of problems for managers and can be fixed through application programming.

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

In a(n) diagram, the arrows above the attributes indicate all desirable dependencies.

What characteristics do tables that conform to the concept of well-informed relations have?

Describe a dependency diagram and explain its purpose.

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

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

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

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

Some very specialized applications may require normalization beyond the .

Data redundancies occur from of data on every row entry.

The is central to a discussion of normalization.

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

Any attribute that is at least part of a key is known as a .

A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key is said to be in .