Advanced level 2025 Holy Infant High School mock Computer science 3
A hotel needs to record information about customers and their bookings. The hotel has two types of room: double
and family. Each room has a unique room number. The hotel stores information about the customers including their
name, address and contact details. When a customer books a room, they give the start date and the number of nights
they want to stay. If a customer wants more than one room, each room must have a separate booking.
Each booking has an ID number. The hotel creates a normalised, relational database to store the required
information. There are three tables:
➢ CUSTOMER (CustomerID, Name, Address, ContactDetails)
| Field | Data Type | Size | Description |
| CustomerID (Primary Key) | Text | 5 | AB101 |
| Name | Text | 20 | Paul Kagame |
| Address | Text | 20 | Lome Qtr, 13, Biyem Assi |
| ContactDetails | Number | Int | Long Integer (679657789) |
➢ ROOM (RoomNumber, RoomType)
| Field | Data Type | Size | Description |
| RoomNumber (Primary Key) | Number | SmallInt | 1001 |
| RoomType | Text | 6 | Double or Family |
➢ BOOKING (BookingID, RoomNumber, CustomerID, StartDate, NumberNights)
| Field | Data Type | Size | Description |
| BookingID (Primary Key) | Text | 5 | 001XY |
| RoomNumber | Number | SmallInt | 1001 |
| CustomerID (Primary Key) | Text | 5 | AB101 |
| StartDate | Date | 01-Jan-05 | |
| NumberNights | Number | SmallInt | 4 |
In a relational Database Management System (RDBMS) of your choice help the hotel implement:
1) Create a database called HDB. Write down the SQL statement you used: (1 mark)
______________________________________________________________________________________
____________________________________________________________________________________
2) Create the above tables in your RDBMS. Write down the SQL statement for each table created
Elwanda Disher
April 4, 2025
This was very helpful—thanks! Bookmarking this one for future reference.