Question: Consider the relations employee name address salary plant num

Consider the relations employee (name, address, salary plant-number) machine (machine-number, type plant-number) Assume that the employee relation is fragmented horizontally by plant-number, and that each fragment is stored locally at its corresponding plant site. Assume that the machine relation is stored in its entirety at the Armonk site. Describe a good strategy for processing each of the following queries.
a. Find all employees at the plant that contains machine number 1130.
b. Find all employees at plants that contain machines whose type is milling machine.
c. Find all machines at the Almaden plant.
d. Find employee x machine.

View Solution:

Sale on SolutionInn
  • CreatedJanuary 29, 2011
  • Files Included
Post your question