Using the below 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;

Various problems with query:

surgeryNo is not part of Owner table;

medNo is not a textual attribute but an integer;

TelNo is not part of Owner (its oTelNo)