Consider supporting us on Patreon. Help us keep revisedeck free.
9. Databases
A section of Computer Science, 0478
Listing 10 of 13 questions
A database table called Booking28 stores details of hotel rooms and bookings for the week beginning Monday 7 July 2025. RoomNo Type Guests Rate$ Mon Tue Wed Thu Fri Sat Sun 101D Double 99.99 T T T T F T T 102D Double 99.99 T T T F T T T 103F Family 150.00 T T T T T T T 104S Single 72.50 F T T F T T T 105S Single 72.50 F T T F T T T 106T Twin 120.00 T T T T F T T 201F Family 160.00 F F T T T T T 202D Double 120.00 T F T T T T T 203T Twin 120.00 T F T T T T T 204T Twin 125.00 T F T F T T T 205S Single 79.99 T F T T F T T 301D Double 200.00 F T T F F T T 302T Twin 200.00 T T T T F T T 303P Suite 500.00 T T T T F T T 304P Suite 700.00 F F F F T T T State the number of fields and records in this database table. Fields Records State the reason why the Type field would not be suitable as a primary key. The database uses only the data types: • alphanumeric • character • Boolean • integer • real • date/time. Complete the table to show the fields that could have the given data types. Only one field name is required in each box and each field name must be different. Field Data type alphanumeric Boolean real integer Give the output that would be produced by the structured query language (SQL) statement: SELECT RoomNo, Type, Guests, Rate$ FROM Booking28 WHERE Mon <> T;
0478_w24_qp_22
THEORY
2024
Paper 2, Variant 2
View
A database table called Hangar1 stores details of a collection of historic aircraft at a museum. ID Make Model Year Engines Airworthy JM1 Hawker Siddeley Nimrod Y JM2 Douglas DC-10 Y JM3 Aérospatiale-BAC Concorde N PB1 De Havilland DH-9 Y PB2 Hawker Fury Y PB3 Hawker Nimrod Y PM1 Fieseler Storch N PM2 Hawker Hurricane Y PM3 Supermarine Spitfire N PM4 Douglas C-47 Dakota N PS1 Boeing 314 Clipper N State the number of fields and records in the database table. Fields Records Give the output that would be produced by the structured query language (SQL) statement: SELECT Model, Year, Engines FROM Hangar1 WHERE Engines > 1 ORDER BY Year; Complete the SQL statement to display only the ID and model of all the aircraft that are airworthy. SELECT ID, ;
0478_s24_qp_23
THEORY
2024
Paper 2, Variant 3
View
Building materials are sold in bags. A new database table called BuildStock has been set up to store details about the materials for sale. Part of this table is given. MtNo Name InStock WeightKg PricePerBag NumberBags MT01 Builders sand Yes 4.50 MT02 Sharp sand Yes 3.50 MT03 Red sand No 2.75 MT04 Cement No 6.85 MT05 Chippings Yes 35.00 MT06 Cobbles No 67.35 MT07 Pebbles small Yes 34.50 MT08 Pebbles medium Yes 25.50 MT12 Pebbles large Yes 62.75 MT15 Washed gravel Yes 12.75 MT16 Pea gravel Yes 15.95 Write the output from this structured query language (SQL) statement. SELECT MtNo, Name FROM BuildStock WHERE WeightKg = 75 ORDER BY PricePerBag; Complete this SQL statement to display only the names of all the materials that are out of stock. SELECT FROM WHERE Explain how another SQL statement using a different field could be used to display the same information.
0478_w24_qp_23
THEORY
2024
Paper 2, Variant 3
View
Questions Discovered
13