Note AcademyNote Academy

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

0478

As printed in the paper

The question as text

A bus company has set up a new database table called ˕½ to store details of the buses leaving the main bus terminal. ÌÍuÏÐÑÒ ÒÐÓÏÔnÖÏÔÍn ×ÏÍpÓ ÒÙÔÚÐÙ ÛÔÜÐ ÌÐÏuÙn 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]

    Boolean

  • 8(a)(ii)[1]

    There are only 2 responses / Only Yes and No / True and False

  • 8(b)[2]

    Two marks for all three correct

    One mark for one/two correct

    BC02 The Fountain 9:10

    BC08 Sunset Quay 12:01

    BC27 The University 16:45

  • 8(c)[3]

    One mark per correct statement

    SELECT Destination

    FROM BUS

    WHERE Return = Yes;

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