Note AcademyNote Academy
Start

Computer Science · Oct / Nov 2022 · Paper 21 · Question 5

0478

As printed in the paper

The question as text

A database table, WAREHOUSE, is used to keep a record of items for sale. The table has these fields: • ItemCode – code to identify each type of item • Description – brief description of each item • Manufacturer – name of manufacturer • Level – number in stock • Price – price in dollars ($).

Read automatically from the paper; the printed page above is exact.

Show the answer and mark scheme

  • 5(a)[2]

    One mark per mark point, max two

    ItemCode
    uniquely identifies each item

  • 5(b)[3]

    One mark per mark point, max three

    correct rows Field, Table and Sort
    correct row Show
    correct Criteria row <10 or <=9

    Field: ItemCode

    Manufacturer

    Level

    Table: WAREHOUSE

    WAREHOUSE

    WAREHOUSE

    Sort:

    Show:

    Criteria:

    <10

    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.