Computer Science · Oct / Nov 2017 · Paper 2 HL · Question 2
Adapt for 2027Entities, data types and queries are covered (A3.2, A3.3.2), but the query parts should be answered in SQL and finding the maximum uses aggregate functions (A3.3.4, HL only).
IBCS
As printed in the paper
The question as text
2. A group of art students have taken three examinations in the school year. Each of the three examinations has a maximum mark of 100. Each student’s total mark for the year is the sum of the marks from the three examinations. The students have passed unless their marks meet one or both of the following failing conditions: yy Scoring less than 30 marks on any one of the three examinations. yy Scoring a total mark that is less than 150. Consider the following relation created by the teacher of this group of students. CLASS_TABLE Student_ID Student_Name Exam_One Exam_Two Exam_Three Total A1209 Ines Prest 30 39 30 99 A1422 Eva Maren 67 29 100 196 C4567 Joe Skrin 100 70 42 212 X0986 Perry Blare 54 68 30 152 B0078 Mia Lorres 26 100 100 226
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
2(a)[3]
2(b)(i)[1]
2(b)(ii)[1]
2(c)[1]
2(d)[4]
2(e)[2]
2(f)(i)[2]
2(f)(ii)[4]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.