Note AcademyNote Academy
Start

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

0478

As printed in the paper

The question as text

A database table, APPLIANCE, is used to keep a record of kitchen appliances available for sale. The following data is stored for each appliance: • CATEGORY – washer, dishwasher, fridge or freezer • ECONOMYRATING – A, B, C or D • MANUFACTURER – Baku or ABC • PRICE – price in $ • CODE – a unique code allocated by the manufacturer e.g. B982 • STOCK – number in stock. The database management system uses these data types: Text Number Currency Boolean The ECONOMYRATING field and MANUFACTURER field have a data type of text.

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

Show the answer and mark scheme

  • 5(a)[4]

    CATEGORY – Text characters / words only used

    PRICE – Currency, the price is in dollars / money

    CODE – Text no calculations required, could be numbers or characters

    STOCK – Number, comparisons and calculations may be required

  • 5(b)[3]

    One mark for correct rows Field and Table

    One mark for correct Show row

    One mark for correct Criteria row

    Field: CATEGORY

    MANUFACTURER

    CODE

    ECONOMYRATING

    Table: APPLIANCE

    APPLIANCE

    APPLIANCE

    APPLIANCE

    Sort:

    Show:

    Criteri

    ="A"

    a:

    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.