Task Expected response Additional guidance Marks available 1 Database design and development — part B 1c (i) Award 1 mark each for: SELECT drugID drugID with COUNT 3 function FROM PrescribedDrug GROUP BY drugID ORDER BY COUNT(drugID) DESC SELECT drugID, COUNT(drugID) FROM PrescribedDrug GROUP BY drugID (7) ORDER BY COUNT(drugID) DESC; 1c (ii) Award 1 mark for query to find Do not award a mark for the the drug with the highest dosage: final bullet point if the candidate answers “AND Query1 dosage = 2000”. This implies Implementation SELECT Max(dosage) FROM they have manually searched Drug; for the drug with the highest dosage. Award 1 mark each for: If the candidate implements 4 the search using a sub-clause: SELECT patientID, AND Drug.dosage = (SELECT datePrescribed MAX(Drug.dosage) FROM FROM PrescribedDrug, Drug Drug;) WHERE PrescribedDrug.drugID still award marks for: = Drug.drugID Query 1 AND dosage = [Query1 result] AND dosage =
Task Expected response Additional guidance Marks available 1 Database design and development — part B 1c (i) Award 1 mark each for: SELECT drugID drugID with COUNT function FROM PrescribedDrug GROUP BY drugID ORDER BY COUNT(drugID) DESC 3 Implementation (7) SELECT drugID, COUNT(drugID) FROM PrescribedDrug GROUP BY drugID ORDER BY COUNT(drugID) DESC; 1c (ii) Award 1 mark for query to find the drug with the highest dosage: Query1 SELECT Max(dosage) FROM Drug; Award 1 mark each for: SELECT patientID, datePrescribed FROM PrescribedDrug, Drug WHERE PrescribedDrug.drugID = Drug.drugID AND dosage = [Query1 result] Do not award a mark for the final bullet point if the candidate answers “AND dosage = 2000”. This implies they have manually searched for the drug with the highest dosage. If the candidate implements the search using a sub-clause: AND Drug.dosage = (SELECT MAX(Drug.dosage) FROM Drug;) still award marks for: Query 1 AND dosage = 4
HigherCATComputingScience.docx