Part 2: 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? 2. For each of the below changes 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. The first one is filled in for you. a. Change MAJOR for STUDENT_ID 02134 - CHANGE MAJOR, CHANGE ADVISOR, CHANGE ADVISON PHONE, CHANGE ADVISOR OFFICE b. Change STUDENT_NAME for STUDENT_ID 03567 - c. Delete ADVISOR for Entomology MAJOR - d. Add new MAJOR - e. Delete record with STUDENT_ID 45678 3. What changes would you make to the design to improve the functionality for adding, removing, and updating data? Would you add additional tables, change the rules of the data, etç? Use the space below to create your table(s) with the new design.
