To solve the problems caused by the merger, no schema changes are required. Merge the customer entity sets removing duplicate tuples with the same social- security field. Before merging the branch entity sets, prepend the old bank name to the branch-name employee entity sets can bemerged directly, and so can the payment entity sets. No duplicate removal should be performed. Before merging the loan and account entity sets, whenever there is a number common in both the banks, the old number is replaced by a new unique number, in one of the banks
