MARK SCHEME – GCSE COMPUTER SCIENCE – 8525/2 – JUNE 2022
7.2 Structured Query Language (SQL) [Link]
Total
Qu Part Marking guidance
marks
01 5 6 marks for AO3 (program) 6
Maximum of five marks if any errors
1 mark: Three correct fields in one SELECT clause;
1 mark: one correct table in FROM clause;
1 mark: second correct table in same FROM clause;
1 mark: a correct condition in WHERE clause;
1 mark: correct conditions and correct usage of AND in WHERE clause //
correct conditions and correct usage of ON with INNER JOIN;
1 mark: a correct ORDER BY clause;
DPT. Use of incorrect key words when their versions are meaningful in the
context of the question, eg GET instead of SELECT or use of AND instead of
commas in FROM clause.
DPT. Incorrect spelling of field names.
A. Table names in front of field names provided the table names are correct
A. == in place of = (for this year only)
I. missing ASC in ORDER BY clause
I. case and spacing
R. missing quotes around ‘Leader’
Sample answer 1
SELECT FirstName, LastName, DatePresented
FROM Member, Award
WHERE [Link] = [Link]
AND AwardName = 'Leader'
ORDER BY DatePresented ASC
Sample answer 2
SELECT FirstName, LastName, DatePresented
FROM Member, Award
WHERE [Link] = [Link]
AND AwardID = 4
ORDER BY DatePresented ASC
Sample answer 3
SELECT FirstName, LastName, DatePresented
FROM Member INNER JOIN Award ON [Link] =
[Link]
WHERE AwardName = 'Leader'
ORDER BY DatePresented ASC
Sample answer 4
SELECT FirstName, LastName, DatePresented
FROM Member INNER JOIN Award ON [Link] =
[Link]
WHERE AwardID = 4
ORDER BY DatePresented ASC
19
MARK SCHEME – GCSE COMPUTER SCIENCE – 8525/2 – JUNE 2022
7.2 Structured Query Language (SQL) [Link]
Total
Qu Part Marking guidance
marks
01 6 2 marks for AO3 (program) 2
Member; A. correct bracketed list of field identifiers after Member
VALUES;
I. case
R. plural of Member
R. singular of VALUES
20
PMT
MARK SCHEME – GCSE COMPUTER SCIENCE – 8525/2 – JUNE 2023
7.2 Structured Query Language (SQL) [Link]
Total
Qu Part Marking guidance
marks
02 4 6 marks for AO3 (program) 6
Note to examiners: if there is more than one set of SQL code you should only
mark the first set of code.
Note to examiners: To award both marks D and E there must not be more than
two conditions within the WHERE clause.
Maximum of 5 marks if any errors.
Mark A for the 4 correct fields in the SELECT clause and no others
Mark B for one correct table in FROM clause
Mark C for second correct table in FROM / JOIN clause and no others
Mark D for correct identification of join, either through WHERE statement or
using INNER JOIN … ON
Mark E for correct condition for YearGroup in WHERE clause
Mark F for correct ORDER BY clause
DPT. consistent use of incorrect key words when their versions are meaningful
in the context of the question, eg GET instead of SELECT or use of AND
instead of commas in FROM clause.
DPT. incorrect spelling of field names.
DPT. consistent use of extraneous characters within the code. eg colons after
keywords
A. Table names in front of field names provided the table names are correct
A. quotes around 11 in where clause
I. missing ASC in ORDER BY clause
I. case and spacing
R. == in place of =
Sample answer:
SELECT FirstName, LastName, CopyID, DepositPaid [A]
FROM Student, Loan [B,C]
WHERE [Link] = [Link] [D]
AND YearGroup = 11 [E]
ORDER BY LastName ASC [F]
Alternative answer:
SELECT FirstName, LastName, CopyID, DepositPaid [A]
FROM Student [B]
INNER JOIN Loan ON [Link] = [Link][C,D]
WHERE YearGroup = 11 [E]
ORDER BY LastName ASC [F]
16
PMT
MARK SCHEME – GCSE COMPUTER SCIENCE – 8525/2 – JUNE 2023
7.2 Structured Query Language (SQL) [Link]
Total
Qu Part Marking guidance
marks
02 5 2 marks for AO3 (program) 2
1 mark for DELETE FROM Loan
1 mark for WHERE CopyID = "PB002" AND StudentID = "TUC004"
A. PB002 and TUC004 with single quotes in the WHERE clause.
I. case and spacing
R. == in place of =
17
MARK SCHEME – GCSE COMPUTER SCIENCE – 8525/2 – SAMS
7.2 Structured Query Language (SQL) [Link]
Total
Qu Part Marking guidance
marks
03 3 6 marks for AO3 (program) 6
1 mark: correct fields in SELECT clause
1 mark: one correct table in FROM clause
1 mark: second correct table in FROM clause
1 mark: a correct condition in WHERE clause
1 mark: correct conditions and correct usage of AND in WHERE clause // correct
conditions and correct usage of AND in WHERE clause and correct usage of ON
with INNER JOIN
1 mark: ORDER BY clause
Max 5 if any errors
Sample answer
SELECT Customer, Date, Time
FROM Booking, Game
WHERE [Link] = [Link]
AND MaxPlayers >= 4
AND GameTableID = 2
ORDER BY Date
I. the inclusion of ASC, DESC in ORDER BY clause
Alternative answer
SELECT Customer, Date, Time
FROM Booking INNER JOIN Game ON [Link] = [Link]
WHERE MaxPlayers >= 4
AND GameTableID = 2
ORDER BY Date
17
MARK SCHEME – GCSE COMPUTER SCIENCE – 8525/2 – SAMS
7.2 Structured Query Language (SQL) [Link]
Qu Part Marking guidance Total
marks
03 4 2 marks for AO3 (refine) 2
1 mark: changing +9 to +10;
1 mark: changing <=3 to >3
UPDATE Game
SET LengthOfGame = LengthOfGame + 10
WHERE Complexity > 3
18
MARK SCHEME – GCSE COMPUTER SCIENCE – 8525/2 – JUNE 2024
7.2 Structured Query Language (SQL) [Link]
Total
Question Part Marking guidance
marks
04 5 2 marks for AO3 (program) 2
1 mark for each correct response for and .
SELECT
Year = 2019
I. Case / spacing
I. Semicolon after 2019
A. Quotation marks around 2019
A. == in place of =
R. if any spelling mistakes
Total
Question Part Marking guidance
marks
04 6 3 marks for AO3 (program) 3
1 mark: correct UPDATE command clause;
1 mark: SET clause completely correct;
1 mark: correct condition in WHERE clause;
Maximum of 2 marks if any errors
Sample answer 1
UPDATE Film
SET Title = 'Toy Story 4'
WHERE FilmID = 101
Sample answer 2
UPDATE Film
SET Title = 'Toy Story 4'
WHERE Title = 'Toy Story 3'
DPT. missing quotation marks
DPT. any spelling mistakes
I. Case / spacing
I. Quotation marks around 101
I. Semicolon at the end of the last line
A. Double quotation marks instead of single
A. == in place of =
18
MARK SCHEME – GCSE COMPUTER SCIENCE – 8525/2 – JUNE 2024
7.2 Structured Query Language (SQL) [Link]
Total
Question Part Marking guidance
marks
04 7 3 marks for AO3 (program) 3
1 mark for each correct response for , and .
Film // Film (FilmID, Title, Year)
Note to Examiners: If field list given in INSERT INTO
command then allow fields in any order, but must include all
three fields.
VALUES
103,'Gladiator',2000
Note to Examiners: If field list given in INSERT INTO
command then values must match order in that command. If
field list not given then values must be in order shown
I. spelling of Gladiator
R. if the answer is surrounded by parentheses
I. Case / spacing
I. Quotation marks around 103 or 2000
A. Double quotation marks instead of single
19