Design a multidatabase query plan and a set of SQL statements that implement the query of the previous exercise.
What will be an ideal response?
1. At site A, perform a SELECT statement on the database at site C that returns the SSnum and Age of all employees for which Title = ‘Manager’. Since there are
50 managers, the total amount of information returned is 50 ? (9 + 6) or 750 bytes
2. At site A, perform a SELECT on the database at site B that returns the entire
EMP21 database. The total amount of information returned is 10000 ? 30 or 3
megabytes.
3. At site A, perform the join of the two tables from steps 1 and 2, and select those names whose salary is greater than their age.
You might also like to view...
________ refers to the likelihood that your computer will run as it was intended
Fill in the blank(s) with correct word
Which tool category allows you to edit vignettes and selective focus??
A. ?filters B. ?light C. ?color D. ?effects