Some one started recording students registration and advisor information as the table below. In this table set up, answer the following questions.

1. The table structure above may raise problems if data are kept being entered the table. What kind of problems in entering and managing the data can you tell with this table structure?
2. To avoid the data recording problems with the above table structure, how would you set up tables and their relationships each other? Write down the structure of potential tables in the format, STUDENT(StudentID, StudentName, AdvisorID) where STUDENT as the name of a table, StudentID as Primary Keys underlined, and AdvisorID as Foreign Key in italic. (Hint: If a many-to-many relationship between tables exists, we need to introduce an association table to convert it into 1-to many relationships.)

Studenti StudentNam Advisor Nam 1022 1022 1022 4123 Kabtum Kabtum Kabtum Won Kim Won Kim Won Kim MIS CourseCod Advisor Email CourseName wekim@wuv.edu ACC502 Financial Accounting wekim@wuv.edu BUS502 Human Resource Mgmt wekim@wuv.edu BUS503 Financial Management BUS504 O&S Chain jcoleman@wuv.edu Management jcoleman@wuv.edu BUSSOS Marketing Management jcoleman@wuv.edu BUS506 ypak@wuv.edu BUS507 Strategic Management ypak@wuv.edu BUS510 Organizational Theory ypak@wuv.edu BUS600 Managerial Statistics De Paula De Paula De Paula Berezhniak Berezhniak Berezhniak 4123 4123 4576 4576 4576 Coleman Coleman Coleman Yop Pak Yop Pak Yop Pak Studenti StudentNam Advisor Nam 1022 1022 1022 4123 Kabtum Kabtum Kabtum Won Kim Won Kim Won Kim MIS CourseCod Advisor Email CourseName wekim@wuv.edu ACC502 Financial Accounting wekim@wuv.edu BUS502 Human Resource Mgmt wekim@wuv.edu BUS503 Financial Management BUS504 O&S Chain jcoleman@wuv.edu Management jcoleman@wuv.edu BUSSOS Marketing Management jcoleman@wuv.edu BUS506 ypak@wuv.edu BUS507 Strategic Management ypak@wuv.edu BUS510 Organizational Theory ypak@wuv.edu BUS600 Managerial Statistics De Paula De Paula De Paula Berezhniak Berezhniak Berezhniak 4123 4123 4576 4576 4576 Coleman Coleman Coleman Yop Pak Yop Pak Yop Pak