notesonly.in

One notebook for every subject — open it anywhere.

Log in

Normalization: 1NF to BCNF

Database Management Systems · Engineering

Study notes

Table (roll, course, teacher, room): teacher depends on course, not on roll. This transitive dependency (2NF but not 3NF) means if a course's teacher changes, many rows update. Split into Enrolls(roll, course) and CourseTeacher(course, teacher): one update fixes all. That's 3NF.

← Back to topics for Engineering