The current rental process is as follows. When a patient needs a specialised mattress, the requestor can either call or email SAM's clerk to inform them about the requirements of the mattress. Either way, the clerk first checks the existence of the client and Patient Unique Identifier (PUID) by entering the PUID into the system. If this is a new client or a new patient, the clerk will add their information to the Client master data and the Patient master data, respectively. Then, the clerk will retrieve the patient information, mattress type/size needed, etc., from the database. The clerk will then retrieve the delivery details from the database and lodge the order. When an order is successfully lodged, the system generates a reference number saved in the Order event data. The requestor could use the reference number later, e.g. to check for the order status, details of charges, etc. Then, the clerk will retrieve a list of mattresses that meet the requirement from the Mattress master data. The clerk will schedule for delivery and inform SAM's drivers. Using the deliver-collect tracking system, drivers examine the mattress, ensuring it is in good condition before delivery. The deliver-collect tracking system is a mobile application that can scan the QR code on a mattress and record its status, e.g. good to deliver, delivered, collected, sanitised, stored, damaged, etc. The deliver-collect tracking system is a separate system from the central computer system used by the clerk. Sometimes it could be a data mismatch, e.g. status not updated from the tracking system, and the drivers or the clerk need to update them manually. Once it is examined, the drivers deliver the mattress to the designated hospital address. When the mattress is no longer needed, the requestor will inform SAM's clerk, and the collection process is carried out by a driver, similar to the delivery process. Finally, the clerk sends the invoice to the client's accountant. Then, the accountant pays the mattress rental fees via EFTPOS, BPAY, or credit card, and sends a copy of the invoice to the patient. The clerk will update the payment information in the Order event data. If the patient claims from their health insurance, the clerk will collect information about the insurance and send an invoice to their insurance company. 1. Prepare a table of entities and activities. (2 marks) 2. Draw a context diagram. (2 marks) The current rental process is as follows. When a patient needs a specialised mattress, the requestor can either call or email SAM's clerk to inform them about the requirements of the mattress. Either way, the clerk first checks the existence of the client and Patient Unique Identifier (PUID) by entering the PUID into the system. If this is a new client or a new patient, the clerk will add their information to the Client master data and the Patient master data, respectively. Then, the clerk will retrieve the patient information, mattress type/size needed, etc., from the database. The clerk will then retrieve the delivery details from the database and lodge the order. When an order is successfully lodged, the system generates a reference number saved in the Order event data. The requestor could use the reference number later, e.g. to check for the order status, details of charges, etc. Then, the clerk will retrieve a list of mattresses that meet the requirement from the Mattress master data. The clerk will schedule for delivery and inform SAM's drivers. Using the deliver-collect tracking system, drivers examine the mattress, ensuring it is in good condition before delivery. The deliver-collect tracking system is a mobile application that can scan the QR code on a mattress and record its status, e.g. good to deliver, delivered, collected, sanitised, stored, damaged, etc. The deliver-collect tracking system is a separate system from the central computer system used by the clerk. Sometimes it could be a data mismatch, e.g. status not updated from the tracking system, and the drivers or the clerk need to update them manually. Once it is examined, the drivers deliver the mattress to the designated hospital address. When the mattress is no longer needed, the requestor will inform SAM's clerk, and the collection process is carried out by a driver, similar to the delivery process. Finally, the clerk sends the invoice to the client's accountant. Then, the accountant pays the mattress rental fees via EFTPOS, BPAY, or credit card, and sends a copy of the invoice to the patient. The clerk will update the payment information in the Order event data. If the patient claims from their health insurance, the clerk will collect information about the insurance and send an invoice to their insurance company. 1. Prepare a table of entities and activities. (2 marks) 2. Draw a context diagram. (2 marks)
