Computer Science · May / June 2016 · Paper 22 · Question 7
2210
As printed in the paper
The question as text
A database, SOFASELECT, was set up to show the prices of suites, sofas and chairs for sale from an online furniture warehouse. Part of the database is shown below. Description Brochure Number Number of Seats Number of Pieces Material Colour Price in $ Sofa SF17 2 1 Leather Red 950 Sofa SF19 3 1 Vinyl Black 1,000 Suite SU10 4 3 Velvet Green 1,500 Suite SU23 5 3 Leather Brown 950 Recliner chair RC01 1 1 Leather Cream 600 Chair CH16 1 1 Vinyl Red 250 Recliner sofa RS23 4 1 Leather Cream 1,200 Chair CH10 1 1 Velvet Red 175
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
7(a)[1]
– 7 [1]
7(b)[2]
– Brochure Number…….. – ….. Uniquely identifies each record/each Brochure Number different/no duplicates [2]
7(c)[2]
– Number of Seats – number/integer – Price in $ – currency/real [2]
7(d)[3]
1 mark for each correct result, 1 mark for the results in descending order of price – Recliner sofa 1,200 RS23 – Recliner chair 600 RC01 [3]
Assignment Iteration Input Output FOR X ← 1 TO 10 READ X PRINT X X ← Y + Z
7(e)[5]
Field: Brochure Number Material Colour Price in $ Number of Seats Table: SOFASELECT SOFASELECT SOFASELECT SOFASELECT SOFASELECT Sort: Show: Criteria: >2 or: (1 mark) (1 mark) (1 mark) (1 mark) (1 mark) [5]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.