Computer Science (AS & A Level) · Oct / Nov 2021 · Paper 12 · Question 6
9618
As printed in the paper
The question as text
A shop sells plants to customers. The shop manager has a relational database to keep track of the sales. The database, PLANTSALES, has the following structure: PLANT(PlantName, QuantityInStock, Cost) CUSTOMER(CustomerID, FirstName, LastName, Address, Email) PURCHASE(PurchaseID, CustomerID) PURCHASE_ITEM(PurchaseID, PlantName, Quantity)
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
6(a)(i)[2]
6(a)(ii)[3]
6(b)[3]
6(c)(i)[4]
6(c)(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.