Group Database Normalization Quiz

What is the main objective of normalization in a database?

• To duplicate data across multiple tables

• To organize data to reduce redundancy and avoid anomalies

• To increase the number of tables in the database

• To allow for multi-valued attributes in each column

Which of the following is a condition for a table to be in First Normal Form (1NF)?

• Columns can contain sets of values

• All values in a column must be unique

• All values in a column must belong to the same domain

• Tables can have repeating groups

Why does a table need to be in 1NF before it can be in 2NF?

• 1NF ensures the table is free from transitive dependencies

• 1NF organizes the table into atomic values, setting the foundation for higher normal forms

• 1NF ensures that all non-prime attributes depend on the primary key

• 1NF eliminates partial dependencies

Which of the following violates Second Normal Form (2NF)?

• A non-prime attribute depending on the entire primary key

• A non-prime attribute depending on part of a composite primary key

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

• All non-prime attributes directly depending on the primary key

Which of the following is an example of a Transitive Dependency?

• Customer_ID → Customer_Name

• • Student_ID → Student_City → Student_State

• • Product_Name → Price

• • Customer_ID → Product_Name

What does Third Normal Form (3NF) aim to eliminate?

• Multi-valued attributes

• Transitive dependencies

• Partial dependencies

• Candidate keys

How is data redundancy eliminated when moving from 1NF to 2NF?

• By merging tables with similar data

• By decomposing the table to eliminate partial dependencies

• By adding additional columns to the table

• By creating composite primary keys

Which of the following statements is true for a table in 2NF?

• It is in 1NF and has no partial dependencies

• It is in 3NF and has no transitive dependencies

• It contains repeating groups

• It allows multi-valued attributes in its columns

Which of the following tables is in Third Normal Form (3NF)?

• A table with partial dependencies

• A table with atomic values but with transitive dependencies

• • A table with no transitive dependencies and no partial dependencies

• • A table with repeating groups

What is the key requirement for a table to be in Boyce-Codd Normal Form (BCNF)?

• The table should be in 1NF

• The table should be in 2NF

• For every functional dependency A → B, A should be a superkey

• The table should have no candidate keys