O-LevelComputer ScienceDatabases2210/22 · Oct/Nov 2018 · Q67 Marks
A database table, PORTRAIT, is used to keep a record of the portraits available from a photographic studio. Each portrait has a unique reference number PICnnn, where n is a single digit, for example PIC123. The studio keeps a record of the size (for example 20 x 15), the type (black and white or colour), and the price in dollars.
- (a)Complete the table to show the most appropriate data type for each of the fields. Field Reference Number Size Type Price in $ Data type[4]
- (b)The results from the query-by-example grid should show the reference number, price, type and size of all portraits under $50. Identify the three errors in the query-by-example grid. Field: Reference No Table: PORTRAIT Sort: Show: Criteria: or: Price in $ PORTRAIT >50.00 Type PORTRAIT Size PORTRAIT Error 1 Error 2 Error 3[3]
Mark scheme
Marking points from the official mark scheme (Oct/Nov 2018). The mark or mark type is shown in brackets.
- [1] 1 mark for each correct row (max 4).
- Reference Number: Text
- Size: Text
- Type: Text/Boolean
- Price in $: Number/Currency
- [1] Incorrect field name for Reference Number
- [1] Incorrect criteria for Price in $ should be <
- [1] Type not checked
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 →