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?

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

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

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

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.