Solved

Case Study 3 - Rapid Roads
Client \quad \quad

Question 6

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;

Correct Answer:

verifed

Verified

Query graph will show that the...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents