Computer Science · Database Management Systems

An analytical evaluation is performed on the functional dependencies of the ENROLLMENT schema (Candidate Key: Roll_No, Course_ID) and the EMPLOYEE schema (Candidate Key: Emp_ID) to check the 3NF formal conditions. The evaluated non-trivial functional dependencies are: I. Roll_No → Student_Name II. (Roll_No, Course_ID) → Grade III. Emp_ID → Dept_ID IV. Dept_ID → Dept_Name V. Course_ID → Course_Name Calculate the exact number of these functional dependencies that strictly VIOLATE the Third Normal Form (3NF) formal conditions.