Management is concerned about data redundancies in a table. There is some data in the table that is redundant and you are questioning what happens if the data is changed. Assume that this is the only table, and all the data is required when a new record is entered. There is only one advisor per major. What happens if the data is redundant and the data is updated, deleted or a new record is added? Think about the following: - What data needs to be changed if you change majors? Think about what attributes are associated with a major. - What data needs to be added if an advisor is deleted? - What happens if you delete a student record and it is only one with a specific advisor? What do you need to do to preserve all the advisor data? Review the specific actions that can occur. What if any changes need to be made to the data in other field(s). Think about redundancy and what happens if all the data is not updated. STUDENT ID 02134 2. Change STUDENT NAME for STUDENT_ID 03567 3. Delete ADVISOR for Entomology MAJOR 1. Change MAJOR for STUDENT_ID 02134 No change 2. Change Update major STUDENT_NAME for Update ADVISOR and MAJOR STUDENT_ID 03567 Update MAJOR, ADVISOR, ADVISOR_PHONE, ADVISOR_OFFICE 3. Delete ADVISOR for Select Entomology MAJOR 4. Add new MAJOR Select 5. Delete record with Select STUDENT_ID 45678 1. Change MAJOR for STUDENT_ID 02134 2. Change STUDENT_NAME for STUDENT_ID 03567 3. Delete ADVISOR for Entomology MAJOR 4. Add new MAJOR 5. Delete record with STUDENT_ID 45678 2. Change STUDENT_NAME for STUDENT_ID 03567 1. Change MAIOR for STUDENT_ID 02134 2. Change STUDENT NAME for STUDENT ID 03567 3. Delete ADVISOR for Entomology MAJOR 4. Add new MAJOR 5. Delete record with No change STUDENT_ID 45678 Insert Dummy STUDENT_ID, dummy STUDENT_NAME, MNOR, ADVISOR, ADVISOR_PHONE, ADVISOR_OFFICE Insert MAOR Insert ADVISOR Belest Ne change Insert ADVisor Insert ADVISOA, MAJOR