O-LevelComputer ScienceDatabases2210/22 · Oct/Nov 2022 · Q78 Marks

A school uses a database table, ASSESS, to keep a record of the internal assessments and the number of candidates for each of the subjects in its curriculum. SubjectCode | SubjectName | Exams | Practicals | Candidates ------------|----------------------|-------|------------|------------ COMP | Computer Science | 2 | 1 | 200 INFO | Information Technology | 1 | 2 | 200 MATH | Mathematics | 3 | 0 | 350 PHYS | Physics | 2 | 1 | 120 CHEM | Chemistry | 2 | 1 | 120 BIOL | Biology | 2 | 1 | 200 GEOG | Geography | 2 | 0 | 200 HIST | History | 2 | 0 | 250 GEOL | Geology | 2 | 0 | 80 PHED | Physical Education | 1 | 2 | 350 FREN | French | 2 | 2 | 120 ENGL | English | 2 | 2 | 350 This database only allows the data types: • text • number • currency • Boolean.

(a)(i)State the most appropriate data type for the fields SubjectCode and Exams. SubjectCode ................................................................................................................................. Exams ............................................................................................................................................[1]
(a)(ii)State one reason why the Candidates field could not be of the Boolean data type.[1]
(b)Show the output given by the query-by-example grid. Field: SubjectName | Practicals | Candidates Table: ASSESS | ASSESS | ASSESS Sort: | | Ascending Show: ✓ | | ✓ Criteria: | <1 | or:[3]
(c)Complete the query-by-example grid to output the subjects with fewer than 150 candidates. Display only the SubjectCode, SubjectName and Candidates fields in order of the number of candidates from largest to smallest. Field: Table: Sort: Show: Criteria: or:[3]

Mark scheme

Marking points from the official mark scheme (Oct/Nov 2022). The mark or mark type is shown in brackets.

[1] SubjectCode Text
[1] Exams Number
[1] The Boolean data type can only have one of two values // the Candidates field has more than two possible values.
[1] correct data
[1] correct layout
[1] correct order
[1] correct fieldnames and table names
[1] correct sort and show rows
[1] correct search criteria

On Oracle Prep you can write or photograph your own answer and have it marked by AI against this mark scheme, with feedback on what you missed.