Answer the following questions:
Question 1: 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, AdvisorNum, AdvisorName, DeptNum, DeptName,
(CourseNum, Description, Term, Grade))
: Draw an ERD for the case given in
Question 1.