Note AcademyNote Academy
Start

Computer Science · Oct / Nov 2022 · Paper 22 · Question 7

0478

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]

    SubjectCode Text

    Exams Number

    Data types must match those given in the question.

  • 7(a)(ii)[1]

    The Boolean data type can only have one of two values // the Candidates field has more than two possible values.

  • 7(b)[3]

    One mark per mark point, max three

    correct data
    correct layout
    correct order

    Expected answer

    Geography 200

    Geology 80

    History 250

    Mathematics 350

  • 7(c)[3]

    One mark per mark point, max three

    correct fieldnames and table names
    correct sort and show rows
    correct search criteria

    Field: SubjectCode

    SubjectName

    Candidates

    Table: ASSESS

    ASSESS

    ASSESS

    Sort:

    Descending

    Show:

    Criteria:

    <150

    or:

Practise this paper →

Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.