Case Study 2 - Complete Pet Care

Essay

Case Study 2 - Complete Pet Care

For a more complete description, see Case Study 4 under Chapter 22.
-Using the above relational schema, determine whether the following query is both type and semantically correct:
SELECT P.petNo, petName, oName, O.TelNo
FROM Pet P, Owner O, Prescription Pr, Medication M, Surgery S
WHERE Pr.medNo = M.medNo AND
S.surgeryNo = O.surgeryNo AND
PR.petNo = P.petNo AND
P.ownerNo = O.ownerNo AND
M.medNo = 'J. Smith' AND adminMethod = 'Oral' AND
S.surgeryNo = 100;