Ch6 Normalization of Database Tables Quiz 6

What is the main goal of normalization?

• Improve data redundancy

• Minimize processing time

• Eliminate data anomalies

• Increase system speed

What does the process of normalization primarily focus on?

• Assigning attributes to tables

• Evaluating database performance

• Simplifying database queries

• Identifying relationships

Which normal form eliminates repeating groups?

• 1NF

• 2NF

• 3NF

• BCNF

A table is in 2NF if it is in 1NF and has no __________.

• Repeating groups

• Transitive dependencies

• Partial dependencies

• Functional dependencies

Which of the following is a characteristic of a well-formed relation?

• Each table represents multiple subjects

• Every table has multiple primary keys

• Each table has no insertion, update, or deletion anomalies

• Each row/column can contain multiple values

When is a table considered to be in BCNF?

• When it is in 3NF and every determinant is a candidate key

• When it is in 2NF and has no partial dependencies

• When it eliminates multivalued dependencies

• When it is fully denormalized

What type of dependency exists when a determinant is only part of the primary key?

• Transitive dependency

• Full functional dependency

• Partial dependency

• Candidate dependency

Which of the following is NOT a normal form?

• 3NF

• 5NF

• 6NF

• BCNF

A transitive dependency occurs when __________.

• An attribute is dependent on another non-primary key attribute

• A primary key determines all non-key attributes

• There is a multivalued dependency

• An entity contains repeating groups

Denormalization often leads to __________.

• Reduced data redundancy

• Increased system performance

• Simplified table structures

• Increased data anomalies