Question: Canadian Maple Trees, Inc. has a distributed relational database with tables in computers in Halifax,Montreal,Ottawa, Toronto, andVancouver. The database consists of twelve tables, some of

Canadian Maple Trees, Inc. has a distributed relational database with tables in computers in Halifax,Montreal,Ottawa, Toronto, andVancouver.

The database consists of twelve tables, some of which are replicated in multiple cities. Among them are tables A, B, and C, with the following characteristics.

TableAconsists of 800,000 records and is located in Halifax, Montreal, and Vancouver.

Table B consists of 100,000 records and is located in Halifax and Toronto.

Table C consists of 20,000 records and is located in Ottawa and Vancouver.

Telecommunications costs among Montreal, Ottawa, and Toronto are relatively low, while telecommunications costs between those three cities and Halifax and Vancouver are relatively high.

A query is issued from Montreal that requires a join of tables A, B, and C. The query involves a single record from table A, 20 records from table B, and an undetermined number of records from table C. Develop and justify a plan for solving this query.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock 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

Students Have Also Explored These Related Database Management Systems Questions!

2. Henry and Judy did not agree to have an open account with Jackson Foods. a) What would be the disadvantages of So Maple having an open account with Jackson Foods? b) If Henry and Judy agreed to an...

Not All Is Sweet for a Maple Syrup Producer Background Henry is the owner of the small maple syrup production company So Maple, based in Quebec, Canada. Henry and his family own a large property with...

MapleX LTD is a private corporation located in northern Ontario that produces maple syrup. The business was established (non-incorporated at the time) in 1978 by Bartosz. Maple syrup is made from...

Background Henry is the owner of the small maple syrup production company So Maple, based in Quebec, Canada. Henry and his family own a large property with hundreds of maple trees. Henry runs the...

Henry is the owner of the small maple syrup production company So Maple, based in Quebec, Canada. Henry and his family own a large property with hundreds of maple trees. Henry runs the business with...

What suggestions do you have to help So Maple protect its profit margin against foreign exchange risk? note - 300 words International Trade Finance Not Auls Sweet for a Maple Syrup Produ ducer 50 50...

Case study Not All Is Sweet for a Maple Syrup Producer Background Henry is the owner of the small maple syrup production company So Maple, based in Quebec, Canada. Henry and his family own a large...

International Trade Finance Not All Is Sweet for a Maple Syrup Producer Background Henry is the owner of the small maple syrup production company So Maple, based in Quebec Canada. Henry and his...

A company owns two different computers, which are in separate buildings and operated entirely separately. Based on past history, Computer 1is expected to break down 5.0 times a year, with a variance...

A 20- F capacitor is discharged through a 5-k resistor. The initial charge on the capacitor is 200C. (a) Sketch a graph of the current through the resistor as a function of time. Label both axes...

Horizontal analySis of income statement fill in boxes and put the increase or decrease in amount and percent

Find the values of m and c which provide the least squares fit to the linear model y = mx + c for the data given in Figure 2.30. Figure 2.30 k XE Yk 1 0 1 2 1 1 3 2 2 4 3 2 5 4 3

Describe the capabilities of the SAP ERP HCM and SuccessFactors systems that were helpful to Steelcase. How did these systems improve global operations and decision making?

What are the issues and technical alternatives to be considered when developing international information systems? Describe the main technical issues facing global systems. Identify some technologies...

What management problems typical of global systems was Crocs experiencing? What management, organization, and technology factors were responsible for those problems?

Required information. [The following information applies to the questions displayed below] The following information is available for ADT Company, which produces special-order security products and...

Variety is often referred to as the: depth of merchandise breadth of merchandise complete retail offering store's supply standard retail mix

Current Attempt in Progress Pharoah Corporation has outstanding at December 31, 2022, 46,500 shares of $18 par value, cumulative, 9% preferred stock and 197.500 shares of $4 par value common stock....