Assignment

You have been requested to develop a healthcare system with the following characteristics: A hospital plans to build a healthcare system, which manages patient information. A hospital has a CEO, 5 doctors, 5 nurses and 3 staff. A doctor works with his/her nurse for treating a patient.

A patient can make an appointment, change, or cancel the appointment by calling a staff in the hospital. When a patient makes an appointment, the patient tells a doctor name to a staff who checks if a doctor is available time from 9 am to 5 pm on a half hourly basis. The appointment is recorded in the system, and updated whenever the patient change or cancel the appointment. An appointment will be cleared when a patient visits the doctor in the hospital.

In case of no-show appointments, the system clears the appointments automatically at 8 pm on a daily basis and charges a penalty $25 to each no-show patient. The hospital does not accept walk-in patients. When a new patient arrives at the hospital, a staff enters to the system the patient information, which includes patient name, address, phone number, email, social security number, and insurance name. Then the staff creates a patient treatment record for the day visit, and adds the record to a list of patients being served by each doctor. For a returning patient, the staff just creates a patient treatment record and adds it to the list of patients for a doctor.

A patient treatment record has the patient name, date to visit a doctor, reason to visit a doctor, patient's weight, height, blood pressure, doctor's treatment content, and prescription if any. The nurse measures a patient's weight, height, and blood pressure every time a patient visits a doctor, updating the patient record with the measurements. The nurse also adds the reason of patient's visit to the doctor to the patient treatment record.

A doctor can look at the next patient record before he/she meets a patient. After treating a patient, a doctor updates a patient record with his treatment content and, if any, prescription. A patient pays for the copay of a doctor visit to the staff just after getting a treatment. A patient can pay it by credit/debit/check/cash. In cases of credit or debit card payment, the payment is validated by the card company, and then the company sends back to the hospital a reference number, which is stored with the patient payment information.

A patient receives a receipt for the payment. In addition, a patient pays an invoice (except for the copay for a doctor's visit) for his/her medical services on-line via the healthcare system. The hospital sends to a patient his/her invoice for any medical services using emails. The patient can access his/her account with the invoice number to pay the invoice using a credit or debit card. The system generates a receipt for the patient's on-line payment and emails it to the patient if the patient wants to receive the receipt using his/her email. The system generates a daily summary report at 9 pm every business day and a monthly report at the end of each month.

The report shows the information on doctors' performance for a day or a month. The report contains each doctor name, the number of patients served by a doctor in a day, and health service income. The monthly report is a summary of daily reports for a month. The daily and monthly reports are stored in the system so that the CEO looks at them any time. The employees in the hospital are allowed to access patient records in the system based on each person's role, such as CEO, doctor, nurse, and staff.

A doctor has all permission on read/write on his patient information and treatment information. A nurse has read/write permission on his/her patient information and treatment information, but he/she cannot write treatment. A doctor or nurse can access only his/her patients' records. A doctor and a nurse are a pair who works together. A staff can create, read/write patient information, create a patient treatment record, and read/write patient payment information. The CEO can look at the daily and monthly reports.

Question :

a.) Develop the interaction model (using communication diagram or sequence diagram) that depicts objects participating in each use case and the sequence of interactions among the objects. A use case is modeled using a communication diagram or sequence diagram.

b.) Design the software architectural model for the healthcare system where the model is defined in terms of subsystems and their interactions. Each subsystem should be represented with objects supporting the subsystem. Define the communication styles between subsystems.

c.) Identify the operations of classes using the interaction model in (a).

d.) Design database tables for the healthcare system. Define the relational database tables for the system. Define the primary key and/or secondary key for each database table, and describe data schema for each database table.