Advanced level 2025 South West Regional Mock computer science 3
Advanced level 2025 South West Regional Mock computer science 3
SECTION A: DATABASE (20 marks)
A database is to be implemented for a supermarket with three tables: Product, Customer, and Transaction, whose names
are of obvious meanings. Each table will serve a specific purpose in organising and managing relevant information as
described by the entities below.
Product(ProdID, ProdName, Price)
Customer(CustID, CustName, Address, Phone)
Transactions(TransID, CustID, ProdID, Quantity, TDate)
Task 1: Creating the Supermarket Database (9 marks)
| (i) | In the description table below, write down a suitable data type for each field in the data type column. The values |
| provided as examples should guide you. | (3 marks) |
