Question: Reconsider the situation described for Exercise 2.26 under the assumption that one bank is in the United States and the other is in Canada. As
Reconsider the situation described for Exercise 2.26 under the assumption that one bank is in the United States and the other is in Canada. As before, the banks use the schema of Figure, except that the Canadian bank uses the social-insurance number assigned by the Canadian government, whereas the U.S. bank uses the social-security number to identify customers. What problems (beyond those identified in Exercise 2.24) might occur in this multinational case? How would you resolve them? Be sure to consider both the scheme and the actual data values in constructing youranswer.

customer account account-number 0..* customer-id 1.1 balance customer-name customer-street customer-city depositor access-date
Step by Step Solution
3.42 Rating (158 Votes )
There are 3 Steps involved in it
This is a case in which the schemas of the two banks differ so the merger becomesmore difficult The ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
16-CS-DB (114).docx
120 KBs Word File
