Computer Science · Oct / Nov 2022 · Paper 22 · Question 7
2210
As printed in the paper
The question as text
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.
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
7(a)(i)[1]
7(a)(ii)[1]
7(b)[3]
7(c)[3]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.