Computer Science (AS & A Level) · May / June 2025 · Paper 13 · Question 6
9618
As printed in the paper
The question as text
A shop sells pens to customers. Customers place an order with the shop and collect the items the next day. The shop uses a database to store the information about the orders. The database contains the following tables: CUSTOMER(CustomerID, CustomerName, Email) ORDER(OrderID, CustomerID, Date, Collected) ORDER_PRODUCT(OrderID, ProductID, Quantity) PRODUCT(ProductID, ProductName, QuantityInBox, Cost, SupplierID) SUPPLIER(SupplierID, SupplierName, SupplierEmail) The primary keys are underlined.
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
6(a)[4]
6(b)[4]
6(c)[4]
6(d)(i)[3]
6(d)(ii)[3]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.