12. using your knowledge of the college environment, determine the

12. using your knowledge of the college environment, determine the

12. using your knowledge of the college environment, determine the

12. Using your knowledge of the college environment, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form.

Student (StudentNum, StudentName, NumCredits, AdvisorNum,
AdvisorName, DeptNum, DeptName, (CourseNum, Description,
Term, Grade) )


12. using your knowledge of the college environment, determine the

12. Using your knowledge of the college environment, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form.

Student (StudentNum, StudentName, NumCredits, AdvisorNum,
AdvisorName, DeptNum, DeptName, (CourseNum, Description,
Term, Grade) )

Leave a Comment