A shop stores orders in one table:
Order(OrderID, OrderDate, CustomerID, CustomerName, CustomerEmail, ProductID, ProductName, Price, Quantity)
Normalise this to third normal form, showing the tables and keys.
From Paper 2 (written)
5.24 marks
Write an SQL query to list the names and prices of products costing more than £20, most expensive first.
From Paper 2 (written)
5.34 marks
Write an SQL query to show the total quantity of products ordered by the customer with email 'ana@example.com'.
From Paper 2 (written)
5.43 marks
Explain what is meant by atomicity and isolation in transaction processing.
Score 0 / 17 · 0 of 4 marked
This paper is written by Plasmo in the style of the AQA A-Level Computer Science exam. It is not a past paper and is not produced or endorsed by the exam board.