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

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

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

Denormalization produces a lower normal form.

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

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

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.

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

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

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

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

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.

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

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

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

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

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

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

Normalization produces a lower normal form.

An atomic attribute .