Database Managment

Consider a Student table containing StudentNum, StudentName, students StudentMajor, students AdvisorNum, students AdvisorName, students AdvisorOfficeNum, students AdvisorPhone, students NumCredits, and students Category (freshman, sophomore, and so on). Do NOT list the functional dependencies that exist, along with the assumptions that would support those dependencies. (Skip functional dependencies) Convert the tables to 3^rd Normal Form using DBDL format. See page 32 for an example right above the Q&A box. For extra credit (2pts), complete an ER diagram using crows feet notation with either LucidCharts or Visio. See dropbox for clarification.

Student( StudentNum, StudetnName, StudentMajor, AdvisorNum, AdvisorName, AdvisorOfficeNum, Advisor Phone, Numcredits, Credits)

12. 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))