Case Study 3 - Rapid Roads
Client $\quad$ $\quad$

Essay

Case Study 3 - Rapid Roads
Client $\quad$$\quad$ (clientNo, cName, cAddress, cTelNo, cFaxNo, officeNo)
Unit $\quad$ $\quad$$\quad$ (unitRegNo, unitDescription, maxPayload, officeNo)
Trailer $\quad$ $\quad$$\quad$ (trailerNo, trailerDescription, trailerLength, maxCarryingWt, officeNo)
ClientOrder $\quad$$\quad$ (orderNo, clientNo, dateOrder, collectDate, collectAddress, deliveryDate, deliveryAddress, loadWeight, loadDescription)
TransportReq $\quad$ (orderNo, unitRegNo, trailerNo)
Staff $\quad$ $\quad$ $\quad$ (staffNo, sName, sAddress, sTelNo, sex, DOB, position, NIN, taxCode, salary, officeNo)
Office $\quad$ $\quad$ (officeNo, oAddress, oTelNo, oFaxNo, countryNo)
Country $\quad$ $\quad$ (countryNo, countryName)
For a more complete description, see Case Study 5 under Chapter 22.
-Now assume that the relation Trailer given in Question 20.7 is horizontally fragmented as follows:

Transform the relational algebra tree from Question 21.7 into a reduced query on fragments. Give a full explanation of the reasoning behind each step and state any transformation rules used during the reduction process.