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 51

True/False

Review LaterAdd Note

Review Later

A good relational DBMS excels at managing denormalized relations.

A) True
B) False

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

In a situation, one key determines multiple values of two other attributes and those attributes are independent of each other.

A) multivalued dependency
B) transitive dependency
C) partial dependency
D) functional dependency

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

Correct Answer

verified

Show Answer

Question 53

Short Answer

Review LaterAdd Note

An attribute that cannot be further subdivided is said to display .

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

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

Explain the Boyce-Codd normal form (BCNF). How is it related to other normal forms?

A(n) exists when there are functional dependencies such that Y is functionally dependent on X, Z is functionally dependent on Y, and X is the primary key.

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

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

A dependency based on only a part of a composite primary key is known as a partial dependency.

Denormalization produces a lower normal form.

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

Normalization produces a lower normal form.

A derives its name from the fact that a collection of multiple entries of the same type can exist for any single key attribute occurrence.

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

An atomic attribute .

Attributes should clearly define participation, connectivity, and document cardinality.

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

In a real-world environment, we must strike a balance between design integrity and .

From a system functionality point of view, attribute values can be calculated when they are needed to write reports or invoices.