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.