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.
-Using the above relational schema, determine whether the following query is both type and semantically correct:
SELECT CO.clientNo, cAddress
FROM TransportReq TR, ClientOrder CO, Client C, Unit U, Trailer T
WHERE CO.clientNo = C.clientNo AND
TR.unitRegNo = U.unitRegNo AND
TR.trailerNo = T.trailerNo AND
maxCarryingWt < maxPayload AND
LoadWeight < maxPayload;