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

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

1 Expert Approved Answer
Step: 1 Unlock

This is a case in which the schemas of the two banks differ so the merger becomesmore difficult The ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

16-CS-DB (114).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!