Boyce-Codd Normal Form (BCNF)
3NF vs. BCNF
student_in_course is 3NF
- Only non-prime columns is grade.
- Each candidate key determines grade.
student_in_course is not BCNF
- sn_old → sn_new is a FD but sn_old is not a superkey.
- sn_new → sn_old is a FD but sn_new is not a superkey.
|