Photo AI

Margaret has introduced a loyalty scheme for the ice cream kiosk customers - Edexcel - GCSE Computer Science - Question 7 - 2019 - Paper 1

Question icon

Question 7

Margaret-has-introduced-a-loyalty-scheme-for-the-ice-cream-kiosk-customers-Edexcel-GCSE Computer Science-Question 7-2019-Paper 1.png

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

Data Structure Diagram

96%

114 rated

Answer

To represent the loyalty scheme members' data, a suitable data structure could be a table with the following columns:

MemberNumberEmailAddressFirstNameTotalSpendCollectedPointsRedeemedPoints
987654Tom@s123.comTom246.3121075
654321Sarah@s123.comSarah22.98160

Data Types:

  • MemberNumber: Integer
  • EmailAddress: Text
  • FirstName: Text
  • TotalSpend: Decimal
  • CollectedPoints: Integer
  • RedeemedPoints: Integer

Join the GCSE students using SimpleStudy...

97% of Students

Report Improved Results

98% of Students

Recommend to friends

100,000+

Students Supported

1 Million+

Questions answered

;