Note AcademyNote Academy

Computer Science · May / June 2018 · Paper 22 · Question 6

2210

As printed in the paper

The question as text

A database table, TREES, is used to keep a record of the trees in a park. Each tree is given a unique number and is examined to see if it is at risk of dying. There are over 900 trees; part of the database table is shown. Tree Number Type Map Position Age in Years At Risk TN091 Acacia A7 250 Y TN172 Olive C5 110 N TN913 Cedar B9 8 N TN824 Banyan A3 50 Y TN021 Pine D5 560 Y TN532 Teak C8 76 Y TN043 Yew B1 340 N TN354 Spruce D4 65 N TN731 Elm B10 22 Y TN869 Oak C9 13 N TN954 Pine E11 3 N

Read automatically from the paper; the printed page above is exact.

Show the answer and mark scheme
  • 6(a)[1]

  • 6(b)[2]

  • 6(c)[4]

Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.