Computer Science · Oct / Nov 2018 · Paper 23 · Question 6
2210
As printed in the paper
The question as text
An online fruit tree specialist sells fruit trees in various sizes. A database table, TREETAB, shows the tree type and, for each size, the price and whether they are in stock. Tree Type Size1 Size1 In Size2 Size2 In Size3 Size3 In Apple 10.95 Yes 14.95 Yes 29.95 Yes Apple 12.95 Yes 14.95 Yes 29.95 Yes Cherry 24.95 No 34.95 No 59.95 Yes Fig 19.95 Yes 29.95 No 49.95 Yes Guava 19.95 No 29.95 No 59.95 No Nectarine 8.50 Yes 11.95 Yes 19.95 Yes Olive 19.95 No 39.95 Yes 59.95 Yes Peach 9.25 No 11.95 Yes 19.95 Yes Pear 10.95 Yes 14.95 Yes 29.95 Yes Plum 8.95 Yes 11.95 Yes 19.95 Yes Pomegranate 12.95 No 18.95 Yes 34.95 No Quince 34.95 Yes 44.95 Yes 84.95 No
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
6(a)[2]
6(b)[3]
6(c)[4]
6(d)[4]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.