Second Normal Form (2NF)

A college records enrolments in one table: which student takes which course, plus the student's name and department.

Student_ID	Course_ID	Student_Name	Department
101	C101	Alice Smith	Science
101	C102	Alice Smith	Science
102	C101	Bob Johnson	Arts
103	C103	Carol White	Commerce

This table is already in first normal form. Every cell holds one value, and there are no repeating groups.

It still has a problem, and 1NF cannot see it. Alice Smith's department is stored twice, once for each course she takes.

.....

Like the course? Get enrolled and start learning!

Reading Progress

0%