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

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 Management System Relational Database Management System (RDBMS)

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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

A) important
B) nonprime
C) prime
D) entity

E) A) and D)
F) A) and C)

Correct Answer

verified

C

Question 3

Short Answer

Review LaterAdd Note

____________________ refers to the level of detail represented by the values stored in a table's row.

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

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

In a real-world environment,changing granularity requirements might dictate changes in primary key selection,and those changes might ultimately require the use of ____________________ keys.

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

Explain normalization and its different forms.

A determinant is any attribute whose value determines other values within a column.

All relational tables satisfy the 1NF requirements.

Data redundancies occur from ____________________ of data on every row entry.

Explain the BCNF.How is it related to other normal forms?

Attribute A ____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.

Dependencies can be identified with the help of a dependency ____________________.

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

Normalization works through a series of stages called normal forms.

Any attribute that is at least part of a key is known as a(n)____________________.

Data redundancy produces ____.

Explain how database designers design and normalize databases.

Denormalization produces a lower normal form.