1. 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.)?

1. Some one started recording student's registration and advisor information as the table below. In this table set up, answer the following questions. (5 points) Students StudentName AdvisorName AdvisorEmail CourseCode CourseName 1022 Kabtum Won Kim wekim@wur.edu ACC502 Financial Accounting 1022 Kabtum Won Kim wekim@wuv.edu BUS5029 Human Resource Mgmt 1022 Kabtum Won Kim wekim@wuv.edu BUS503 Financial Management 4123 De Paula Coleman jcoleman@wuv.edu BUS504 O&S Chain Management 4123 De Paula Coleman jcoleman@wuv.edu BUS505 Marketing Management 4123 De Paula Coleman jcoleman@wuv.edu BUS506 MIS 4576 Berezhniak, Yop Pak ypak@wuv.edu BUS507 Strategic Management 4576 Berezhniak Yop Pak vpak@wuv.edu BUS510 Organizational Theory 4576 Berezhniak Yop Pak ypak@wuv.edu BUS600 Managerial Statistics