Computer Science (AS & A Level) · Oct / Nov 2023 · Paper 11 · Question 3
9618
As printed in the paper
The question as text
A shop manager has designed a relational database to store customer orders. The database will have the following tables: CUSTOMER(CustomerID, FirstName, LastName, Town) SHOP_ORDER(OrderNo, CustomerID, OrderDate) SUPPLIER(SupplierID, EmailAddress, TelephoneNumber) ITEM(ItemNumber, SupplierID, Description, Price) ORDER_ITEM(ItemNumber, OrderNo, Quantity)
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
3(a)[3]
3(b)[3]
3(c)(i)[1]
3(c)(ii)[4]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.