Computer Science (AS & A Level) · Oct / Nov 2024 · Paper 13 · Question 4
9618
As printed in the paper
The question as text
A company makes ice cream and sells it to shops. The ice cream is made in batches: a large quantity of one type and flavour of ice cream that is then split into smaller quantities for sale. The company’s owner has designed a relational database, ICECREAM, to store data about their ice cream and customers. Some of the tables in the database are given. The database is not normalised. BATCH(BatchID, Type, Flavour, Size, SellingPrice, EndDate) CUSTOMER(CustomerID, CompanyName, EmailAddress, TelephoneNumber) SALE(SaleID, BatchID, CustomerID, Quantity, Date)
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
4(a)[2]
4(b)[3]
4(c)(i)[5]
4(c)(ii)[4]
4(d)[2]
4(e)[3]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.