Consider two separate banks that decide to merge. Assume that both banks use exactly the same E-R database schema?the one in Figure below (This assumption is of course highly unrealistic; we consider the more realistic case in Section 19.8.) If the merged bank is to have a single database, there are several potential problems:

a. The possibility that the two original banks have branches with the same name

b. The possibility that some customers are customers of both original banks

c. The possibility that some loan or account numbers were used at both original banks (for different loans or accounts, of course) for each of these potential problems, describe why there is indeed a potential for difficulties. Propose a solution to the problem. For your solution, explain any changes that would have to be made and describe what their effect would be on the schema and the data.

customer account account-number 0..* customer-id 1..1 customer-name balance customer-street customer-city depositor access-date