Question 1 Report
A large furniture store uses a computerised system to manage customer orders.
(a) Complete the table showing data items stored for each customer order.
| Data item | Example | Reason for storing |
|---|---|---|
| Order number | ||
| Customer address | ||
| Expected delivery date |
[6]
| Data item | Example | Reason for storing |
|---|---|---|
| Order number | ORD-20250815-001. [1] | To uniquely identify each order so it can be tracked, referenced and retrieved quickly when the customer makes an enquiry. [1] |
| Customer address | 14 Oak Lane, Cambridge, CB2 1TN. [1] | To know exactly where to deliver the furniture and to provide the delivery team with accurate directions. [1] |
| Expected delivery date | 25/08/2025. [1] | To schedule the delivery logistics, assign a delivery slot and inform the customer when to expect their order so they can be at home. [1] |
Everything you need to excel in your exams