Create a view that will display name, department number, and total income (salary+commission) of each employee in department 10. Prevent change of department through the view.

A mixture of programming language and human language is known as:

a. Algorithms b. Recipes c. Directions d. Pseudocode

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;