O-LevelComputer ScienceDatabases2210/22 · Oct/Nov 2021 · Q66 Marks
A pet supplier uses the database table, STOCK, to keep records of its products for pets. The fields are: Field name Description ProductID code to identify the product ProductName name of product ProductDescription information about the product Animal type of animal the product is for, e.g. cat, bird, horse ProductType type of product, e.g. food, toy, medicine InStock whether the product is in stock or not
- (a)(i)Identify the field that could have a Boolean data type.[1]
- (a)(ii)Identify the field that should be used as the primary key.[1]
- (b)Complete the query-by-example grid to output the products intended for a cat that are in stock. Display only the primary key and the name of the products. The output should be sorted by the primary key. Field: Table: Sort: Show: Criteria: or:[4]
Mark scheme
Marking points from the official mark scheme (Oct/Nov 2021). The mark or mark type is shown in brackets.
- [1] InStock
- [1] ProductID
- One mark for correct fieldnames
- One mark for correct table names and show fields
- One mark for correct sort
- One mark for correct search criteria in all columns
- Field: ProductID ProductName Animal InStock
- Table: STOCK STOCK STOCK STOCK
- Sort: Ascending
- Show: ✔ ✔ □ □
- Criteria: ="cat" =Yes
- or:
Write your answer and get it marked
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.
Sign up free →