Computer Science (AS & A Level) · May / June 2025 · Paper 11 · Question 5

A company builds and sells furniture to customers. The company stores data about customers, their payment cards and their furniture orders in a database. The database, FURNITURE, has the following tables: CUSTOMER(CustomerID, Name, Phone) CUSTOMER_CARD_DATA(CardID, CustomerID, CardType, CardNumber, EndDate) ORDER(OrderID, CustomerID, TotalCost, Paid, OrderDate, Complete) ORDER_ITEM(OrderItemID, OrderID, Type, Height, Width, Depth, Details) The primary keys are underlined in each table. The attribute Complete in the table ORDER stores the Boolean value TRUE if the order has been built and FALSE if the order has not been built.

Read automatically from the paper; the printed page above is exact.