O-LevelComputer ScienceDatabases2210/22 · Oct/Nov 2020 · Q77 Marks
The table AUDIOPARTS stores the part number, description, cost and quantity in stock of the items sold by a music shop. PartNum | Description | Cost | Quantity --- | --- | --- | --- A01 | Compact Amplifier Case | 50.00 | 15 A02 | Deluxe Amplifier Case | 75.00 | 1 A03 | Amplifier Standard | 79.99 | 48 A04 | Amplifier Midrange | 149.99 | 50 A05 | Amplifier Megablaster | 299.99 | 48 S01 | Tweeter | 59.99 | 10 S02 | Midrange Woofer | 99.99 | 0 S03 | Subwoofer | 139.99 | 16 S04 | Tower Speaker Basic | 159.99 | 25 S05 | Tower Speaker Skyscraper | 219.99 | 9 S06 | Centre Speaker | 149.99 | 25 S07 | Soundbar | 89.99 | 2 S20 | Soundbar | 129.99 | 0 S21 | Ceiling Surround Speaker | 75.00 | 15 S22 | Ceiling Full Range Speaker | 100.00 | 1 S25 | Surround Speaker | 100.00 | 60 T19 | Speaker Stands (Pair) | 75.00 | 60
- (a)State the number of records in the table AUDIOPARTS[1]
- (b)Identify the field that is most suitable to be a primary key and give a reason for your choice. Fieldname Reason[2]
- (c)Complete the query-by-example grid to show the items where the quantity in stock is fewer than 10. Show all the fields from the database table in descending order of cost. Field: Table: Sort: Show: Criteria: or:[4]
Mark scheme
Marking points from the official mark scheme (Oct/Nov 2020). The mark or mark type is shown in brackets.
- [1] 17
- [2] One mark for correct fieldname and one mark for correct reason
- PartNum
- The data stored in this field is unique for each record
- [4] One mark for correct field and table rows
- One mark for sort row
- One mark for show row
- One mark for correct criteria
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 →