Database Normalization Quiz

What is the main purpose of database normalization?

• To increase redundancy

• To avoid complexities and eliminate duplicates

• To create more tables

• To make data less organized

Which of the following is NOT a type of normalization?

• 3NF

• 2NF

• 1NF

• 4DF

What must a table have to be in the First Normal Form (1NF)?

• Multiple values in a single cell

• A primary key for identification

• Duplicated rows

• No primary key

What does a foreign key do?

• It relates to the primary key in another table

• It uniquely identifies a row in a table

• It eliminates redundancy

• It is a composite of multiple columns

Which normal form eliminates transitive partial dependency?

• 1NF

• 2NF

• 4NF

• 3NF

What is a composite key?

• A key that is used for redundancy

• A key that is not unique

• A key that has multiple columns

• A key that is only one column

In which normal form must a table be to qualify for 2NF?

• 1NF

• 3NF

• 5NF

• 4NF

What is an example of a primary key?

• Home state

• Employee name

• Job title

• Employee ID

Which of the following statements is true about 3NF?

• It eliminates all redundancy

• It requires a table to be in 2NF

• It is the first normal form

• It allows for transitive dependencies

What is the first step in database normalization?

• Creating multiple tables

• Eliminating all data

• Identifying primary keys

• Combining all data into one table