Using the table structures you created (in first attachment called "Table Stucture", remove all transitive dependencies, and draw the new dependency diagrams in Visio. Also identify the normal forms...

1. Using the table structures you created (in first attachment called "Table Stucture", remove all transitive dependencies, and draw the new dependency diagrams in Visio. Also identify the normal forms for each table structure you created. If necessary, add or modify attributes to create appropriate determinants or to adhere to the naming conventions.  **Original table stucture used to draw the fist attachment is attached i=as "Table Structure Orginal"

Extracted text: STUDENT STUDENT ID STUDENT_NAME ADVISOR ID ADVISOR ADVISOR_NAME DEPARTMENT_CODE ADVISOR ID DEPARTMENT DEPARTMENT CODE DEPARTMENT_NAME APPOINTMENT STUDENT ID ADVISOR ID APPOINTMENT_DATE


Extracted text: Attribute Name Sample Value Sample Value Sample Value Sample Value STUDENT ID 123456 123456 478596 389987 Kim Brutt STUDENT_NAME Donald Nouglle Kim Brutt Mary King ADVISOR_ID 123 473 567 123 John Smith ADVISOR_NAME John Smith Kim Young Julia Roberts DEPARTMENT_CODE AIT ЕСЕ CS AIT DEPARTMENT NAME Applied Information Computer Technology Electrical Applied Information Technology Engineering Science APPOINTMENT_DATE 01/01/2009 05/03/2009 03/06/2009 01/01/2009