Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please Help HealthCare System (HCS) Problem Description A hospital plans to build a healthcare system, which manages patient information. A hospital has a CEO, doctors,

image text in transcribed

image text in transcribed

Please Help

HealthCare System (HCS) Problem Description A hospital plans to build a healthcare system, which manages patient information. A hospital has a CEO, doctors, nurses and staff. A patient can make an appointment, change, or cancel the appointment by calling a staff in the hospital. When a patient makes an appointment, she/he tells a doctor name to a staff who checks if the doctor is available from 9 am to 5 pm on a half hourly basis. The appointment is recorded in the system, and it is updated whenever the patient changes or cancels the appointment. Each appointment will be cleared after a patient visits a doctor in the hospital. In case of no-show appointments, the system clears the appointments automatically at8 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, the staff enters the patient information to the systenm for check-in, which includes patient name, address, phone number, social security number, and health insurance information. The patient's doctor visit request is sent to the health insurance company, which approves or denies the request. If the health insurance company approves the patient's doctor visit request, the patient name is added to a list of patients being served bya doctor. If the health insurance company denies the patient's doctor visit request, the patient should cancel his/her doctor visit or pay all the cost of doctor visit without the health insurance coverage. If the patient wants to cancel, the staff terminates the registration of a patient. If the patient desires to pay all the cost out of his pocket, the patient name is added to a list of patients being served by each doctor. For a returning patient, the staff updates the patient information and the patient's doctor visit request is sent to the health insurance company. The remaining process is the same as a new patient's doctor visit depending on the health insurance's approval or The nurse measures a patient's weight, height, and blood pressure each time a patient visitsa doctor, updating the patient record with the measurements. The nurse also adds the reason of patient's visit to the doctor to the patient record. After treating a patient, a doctor updatesa patient record with his treatment content and, if any, prescription. A patient pays for the copay or all the cost of the doctor visit to the staff just when checking out. A patient can pay it by credit/debit/cash. In cases of credit or debit card payment, the payment is validated by the card company, and, if approved, the company sends a reference number to the hospital, which is stored with the patient's payment information. A patient receives a receipt for the payment. 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 each day HealthCare System (HCS) Problem Description A hospital plans to build a healthcare system, which manages patient information. A hospital has a CEO, doctors, nurses and staff. A patient can make an appointment, change, or cancel the appointment by calling a staff in the hospital. When a patient makes an appointment, she/he tells a doctor name to a staff who checks if the doctor is available from 9 am to 5 pm on a half hourly basis. The appointment is recorded in the system, and it is updated whenever the patient changes or cancels the appointment. Each appointment will be cleared after a patient visits a doctor in the hospital. In case of no-show appointments, the system clears the appointments automatically at8 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, the staff enters the patient information to the systenm for check-in, which includes patient name, address, phone number, social security number, and health insurance information. The patient's doctor visit request is sent to the health insurance company, which approves or denies the request. If the health insurance company approves the patient's doctor visit request, the patient name is added to a list of patients being served bya doctor. If the health insurance company denies the patient's doctor visit request, the patient should cancel his/her doctor visit or pay all the cost of doctor visit without the health insurance coverage. If the patient wants to cancel, the staff terminates the registration of a patient. If the patient desires to pay all the cost out of his pocket, the patient name is added to a list of patients being served by each doctor. For a returning patient, the staff updates the patient information and the patient's doctor visit request is sent to the health insurance company. The remaining process is the same as a new patient's doctor visit depending on the health insurance's approval or The nurse measures a patient's weight, height, and blood pressure each time a patient visitsa doctor, updating the patient record with the measurements. The nurse also adds the reason of patient's visit to the doctor to the patient record. After treating a patient, a doctor updatesa patient record with his treatment content and, if any, prescription. A patient pays for the copay or all the cost of the doctor visit to the staff just when checking out. A patient can pay it by credit/debit/cash. In cases of credit or debit card payment, the payment is validated by the card company, and, if approved, the company sends a reference number to the hospital, which is stored with the patient's payment information. A patient receives a receipt for the payment. 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 each day

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Analysis Using SQL And Excel

Authors: Gordon S Linoff

2nd Edition

111902143X, 9781119021438

More Books

Students also viewed these Databases questions