A. Data Redundancy

The following excel table shows columns for Gwinnett bank staff's information including their staff number, names, positions, salaries, and their working branches, and their branch's addresses. There are some redundant data in bAddress (branch Address).

Question 1

Show at least one modification problem that will occur when inserting, updating, or deleting data in the given list using given values. Then briefly talk about the problem with examples using specific values in records or columns. Do not use general terms or sentences that can be an answer to any example. You need to provide the best answer showing you understood why we need to change from one table to two tables. You won't get any credit if you do so.

Staff Rranch