Comments - Database Normalization: Boyce-Codd Normal Form
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
If Instructor Determines Course, It Becomes X And Course Becomes Y. In Functional Dependency X Determines Y. But The Condition For BCNF Is That Y Should Be A Subset Of X i.e. Trivial Functional Dependency Is A Prerequisite. Course Can't Be Subset Of Instructor As Each Course Can Have One Or More Instructors. Moreover, Each Instructor Takes Only One Course Which Seems True For Functional Dependency But Not For Trivial Functional Dependency. If The Situation Is Reversed Such That Each Instructor Can Teach One Or More Courses And Each Course Has Only Instructor. Then Course Becomes X And Determines Y i.e. Instructor, Even Then Y Never Becomes Subset Of X. Instead X Becomes Subset Of Y In Both Cases, Situation Reversed Or Not.