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.