Chapter 5

What is the main goal of normalization?

• Add more tables to the database

• Minimize redundancy and avoid anomalies

• Speed up queries

• Convert SQL to ERD

Which of the following is NOT a type of anomaly?

• Update

• Foreign key

• Insertion

• Deletion

What causes an update anomaly?

• Redundant data stored in multiple rows

• Missing foreign key

• Incomplete primary key

• Empty table

In 1NF, a table must NOT contain:

• Repeating groups

• Primary keys

• NULL values

• Foreign keys

Which of the following ensures a table is in 1NF?

• All attributes are atomic and have no repeating groups

• All attributes are numeric

• All rows are unique

• All values are sorted

What is a partial dependency?

• Non-key attribute depends only on part of a composite key

• Attribute depends on foreign key

• Primary key is divided

• Multiple foreign keys exist

What is required for 2NF?

• Only atomic values

• No partial dependencies and already in 1NF

• No transitive dependencies

• At least two candidate keys

Which of the following violates 3NF?

• A non-key attribute depends on another non-key attribute

• No foreign keys

• Atomic values only

• NULL values in a column

What is a transitive dependency?

• When foreign key depends on primary key

• A non-prime attribute depends on another non-prime attribute

• When a key points to itself

• When two entities depend on each other

To move from 2NF to 3NF, we must remove:

• Composite keys

• Transitive dependencies

• Repeating groups

• Surrogate keys