Note AcademyNote Academy

Computer Science · May / June 2025 · Paper 21 · Question 8

2210

As printed in the paper

The question as text

A bus company has set up a new database table called BUS to store details of the buses leaving the main bus terminal. RouteID Destination Stops Driver Time Return BC01 Town Centre 10 B Smith 9:00 Yes BC02 The Fountain 5 A Patel 9:10 Yes BC03 The Palace 9 B Hayes 9:28 No BC04 City Park 12 W Gao 9:55 Yes BC05 City Mall 9 R Hussein 10:10 No BC06 Swan Lake 14 S Clarke 10:33 No BC07 Guildhall Square 7 J Page 11:34 No BC08 Sunset Quay 6 A Patel 12:01 Yes BC10 Fort Worthington 15 E Carr 12:01 Yes BC12 The Observatory 18 B Smith 13:27 No BC14 East Seaport 11 B Scott 14:07 No BC15 The Football Ground 12 J Page 14:46 Yes BC19 The Cricket Ground 11 B Hayes 15:14 No BC23 Temple Ruins 14 W Gao 16:16 No BC27 The University 9 A Patel 16:45 No

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

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

  • 8(a)(ii)[1]

  • 8(b)[2]

  • 8(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.