A video store is considering installing a ‘self-checkout’ system where customers can borrow videos by scanning their membership cards and videos and pay by EFTPOS. A ‘self-checkout’ transaction has three steps:
• Membership validation;
• Borrowing limit check;
• Payment processing.
For membership validation the barcode on the membership card is used to access the member database to find a match. The customer proceeds to the scanning of videos if the membership is valid otherwise a message is displayed. Using the video barcode data and details from the member database, the system checks that no more than six videos are borrowed. A message is displayed if the limit is exceeded.
Payment processing involves the calculation of borrowing charges, the scanning of the customer’s EFTPOS card, and the entry of a personal identification number and the electronic communication of these details to the financial institution. Video charges are obtained from the video database via the video barcodes. Transaction details are written to the transaction file for each video borrowed.
(i) Plan a strategy to accomplish this task using an appropriate project plan.
(ii) Create a form/screen to display appropriate data.
(iii) Draw a dataflow diagram with the three processes that represents this proposed ‘self-checkout’ system, ensuring that you show external entities and data stores.
(iv) Create appropriate databases and a schema that explains your system
(v) Discuss appropriate backup procedures for the proposed system.
• Membership validation;
• Borrowing limit check;
• Payment processing.
For membership validation the barcode on the membership card is used to access the member database to find a match. The customer proceeds to the scanning of videos if the membership is valid otherwise a message is displayed. Using the video barcode data and details from the member database, the system checks that no more than six videos are borrowed. A message is displayed if the limit is exceeded.
Payment processing involves the calculation of borrowing charges, the scanning of the customer’s EFTPOS card, and the entry of a personal identification number and the electronic communication of these details to the financial institution. Video charges are obtained from the video database via the video barcodes. Transaction details are written to the transaction file for each video borrowed.
(i) Plan a strategy to accomplish this task using an appropriate project plan.
(ii) Create a form/screen to display appropriate data.
(iii) Draw a dataflow diagram with the three processes that represents this proposed ‘self-checkout’ system, ensuring that you show external entities and data stores.
(iv) Create appropriate databases and a schema that explains your system
(v) Discuss appropriate backup procedures for the proposed system.
Last edited:
