Third Normal Form (3NF) in DBMS Theory - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is Third Normal Form (3NF) in database design?

Third Normal Form (3NF) is a database design rule that ensures a table is free from transitive dependencies. This means every non-key column depends only on the primary key, not on other non-key columns.

beginner

What does it mean for a table to have transitive dependency?

A transitive dependency occurs when a non-key column depends on another non-key column, which in turn depends on the primary key. This can cause redundancy and update problems.

intermediate

Which normal form must a table satisfy before it can be in 3NF?

A table must be in Second Normal Form (2NF) before it can be in Third Normal Form (3NF). 2NF means no partial dependency on a part of a composite key.

beginner

Why is Third Normal Form important in databases?

3NF reduces data duplication and improves data integrity by ensuring that non-key columns depend only on the primary key, making the database easier to maintain and update.

intermediate

Give a simple example of a transitive dependency that violates 3NF.

If a table has columns: StudentID (primary key), StudentName, DepartmentName, and DepartmentHead, and DepartmentHead depends on DepartmentName (a non-key column), then DepartmentHead depends transitively on StudentID through DepartmentName, violating 3NF.

Which of the following best describes Third Normal Form (3NF)?

A No transitive dependencies; non-key columns depend only on the primary key

B No partial dependencies; all columns depend on the whole primary key

C No duplicate rows in the table

D All columns are atomic and indivisible

3NF requires that non-key columns depend only on the primary key, eliminating transitive dependencies.

Before a table can be in 3NF, it must be in which normal form?

A 2NF

B 1NF

C BCNF

D 4NF

A table must be in Second Normal Form (2NF) before it can be in Third Normal Form (3NF).

What problem does 3NF mainly address in database tables?

A Non-atomic columns

B Partial dependencies

C Duplicate rows

D Transitive dependencies

3NF removes transitive dependencies to reduce redundancy and improve data integrity.

Which of these is an example of a transitive dependency?

A StudentID → StudentName

B StudentID → DepartmentName → DepartmentHead

C StudentID → CourseID

D StudentID → StudentAddress

DepartmentHead depends on DepartmentName, which depends on StudentID, creating a transitive dependency.

What is a benefit of having a database in 3NF?

A Faster queries always

B No need for backups

C Reduced data redundancy and easier updates

D More columns in each table

3NF reduces data duplication and makes updates easier by organizing data properly.

Explain Third Normal Form (3NF) and why it is important in database design.

Think about how columns relate to the primary key and to each other.

Describe a real-life example where a transitive dependency might occur and how 3NF would fix it.

Consider a table with student info and department info mixed.