Your company is concerned there is a problem with the design of some of the database tables. They want you to look at the tables and determine if there is a problem. Management is concerned about data anomalies and data redundancies. They have stressed it is important to have correct design as it is used for making decisions and used as a basis for reports in the various departments. Examine the fields in each table and determine if the table is designed correctly or incorrectly. Select the dropdown that is appropriate for each table. Student STUDENT AD STUDENT NAME ADVISOR ADVISOR OFFICE DORMADORES VORM 021345 Melissa, Tandy Snow 145 Mountain Hall Peaceful Hall 123 Peace In. 035678 Mary Cindy Lou, Hardie 324 Flower Hall Tulip Hall 789 Tulip in. 5578 Clayton, Harvey Snow 145 Mountain Hall Bee Hall 45 Bee In. 27869 William, Zander Harvey 145 Mountain Hall 123 Peace In Peaceful Hall Advier MOVISOR 10 ADVISORNARE ADVISORLAME ADVISOR OFFICE ADVISON PHON 1023 Melissa Snow 145 Mountain Hall 775.345.9045 msnow@gmail.com 3698 Cindy Lou Harris 324 Flower Hall 775.345.7482 charr@gmail.com 7892 Clayton Harvey 365 Sandy Hall 775.345.7350 charv@gmail.com 1359 William Bonahan 145 Mountain Hall 775.345.8945 wbona@gmail.com Dorm DORM_ID STUDENT_FNAME STUDENT_LNAME DORM DORM_ADDRESS 001 Jigisha Patel Peaceful Hall 123 Peace In 002 Jose Moreno Tulip Hall -789 Tulip in 003 Briana McDogual Bee Hall 45 Bee Ln. Cindy Chui Peaceful Hall 123 Peace Ln. Cindy Chui Peaceful Hall 123 1. Student Selyst Select Correct 2. Advisor Incorrect 3. Dorm Select Oleon Rey co7ds13h.Ch01.04 1. Student Select 2. Advisor Select Select Correct Incorrect 3. Dorm 0-Icon Key cods13h.ch01.01 1. Student 123 Pea Select 2. Advisor Select V 3. Dorm Select Select Correct Incorrect Oleone