Third Normal Form (3NF)

A college keeps one row per student, with the student's department and the department's building.

Student_ID	Student_Name	Department_ID	Department_Name	Department_Location
101	Alice Smith	D01	Science	Building A
102	Bob Johnson	D02	Arts	Building B
103	Carol White	D03	Commerce	Building C
104	Dev Patel	D01	Science	Building A

The key is Student_ID, a single column, so this table is automatically in second normal form. There is no composite key for a partial dependency to hide behind.

It still repeats data

.....

Like the course? Get enrolled and start learning!

Reading Progress

0%

Vote for new content