Database Management

Using your knowledge of the college environment, determine the convert this table to an equivalent collection of tables that are in third normal form using DBDL For extra credit (2pts), complete an ER diagram using crows feet notation with either LucidCharts or Visio. See dropbox for clarification. (Clue: Num fields usually indicate a key field.)

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