Note AcademyNote Academy

Computer Science · Oct / Nov 2017 · Paper 22 · Question 6

2210

As printed in the paper

The question as text

A database table, TRAIN, is to be set up for a railway company to keep a record of the engines available for use. Each engine has a unique number made up of 5 digits, nnnnn. The engines are classified as freight (F) or passenger (P) together with a power classification that is a whole number between 0 and 9, for example F8. The railway company keeps a record of the date of the last service for each engine.

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

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

  • 6(b)[1]

  • 6(c)[3]

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