Database Normalization Quiz

Which of the following tables is in the first normal form (1NF)?

• 
• 
• 

Which of the following is an example of a transitive dependency?

• 
• 
• 
• NONE OF THEM

Which normal form does the following table violate?

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

Which of the following statements is true regarding database normalization?

• It decreases data redundancy.

• It increases data redundancy.

• It has no impact on data redundancy.

Which normal form eliminates transitive dependencies?

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

What is the primary goal of database normalization?

• To increase data redundancy.

• To simplify the database schema.

• To store data in a non-relational format.

What is the purpose of the Foreign Key in a relational database?

• It uniquely identifies each record in a table.

• It establishes a link between two tables based on a related field.

• It ensures that a table has a primary key.

Which normal form allows partial dependency?

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

Is Table A in a normalized form? If not, identify the normalization issue(s).

Is Table B in a normalized form? If not, identify the normalization issue(s).