Photo AI
Margaret has introduced a loyalty scheme for the ice cream kiosk customers - Edexcel - GCSE Computer Science - Question 7 - 2019 - Paper 1
Question 7
Margaret has introduced a loyalty scheme for the ice cream kiosk customers. (a) Each month, Margaret emails a statement to the loyalty scheme members. An example st... show full transcript
Worked Solution & Example Answer:Margaret has introduced a loyalty scheme for the ice cream kiosk customers - Edexcel - GCSE Computer Science - Question 7 - 2019 - Paper 1
Step 1
Draw a data structure diagram
Answer
To represent the loyalty scheme data structure, I would use a table-like diagram that contains the following columns:
- MemberNumber (Integer)
- EmailAddress (Text)
- FirstName (Text)
- TotalSpend (Decimal)
- CollectedPoints (Integer)
- RedeemedPoints (Integer)
Here is an example of how the data structure could be represented:
| MemberNumber | EmailAddress | FirstName | TotalSpend | CollectedPoints | RedeemedPoints |
|--------------|-------------------|-----------|------------|-----------------|----------------|
| 987654 | Tom@123.com | Tom | 246.31 | 210 | 75 |
| 654321 | Sarah@sarah.com | Sarah | 22.98 | 16 | 0 |
In this diagram:
- Each row represents a unique member of the loyalty scheme.
- The data types are clearly defined for each column, ensuring clarity and ease of access.