Computer Science · Database Management Systems

An analytical evaluation is performed on the functional dependencies of the COURSE_TEACHER schema (Candidate Keys: (Student, Course) and (Student, Teacher)) and the EMPLOYEE schema (Primary Key: Emp_ID). The following non-trivial functional dependencies are verified: I. (Student, Course) → Teacher II. Teacher → Course III. Emp_ID → Dept_ID IV. Dept_ID → Dept_Name Calculate the exact number of these functional dependencies that mathematically pass the Third Normal Form (3NF) but strictly VIOLATE the Boyce-Codd Normal Form (BCNF).