290 likes | 474 Views
Stark & Associates Health Clinic. E-R Diagram & Design Project Team Shawn Conatser Madhusudan Gupta Shyam Sundar Bhelle. Table of Contents. System Concept Structure Chart E-R Diagram Physical Design Input Output Appendix A – Business Background Appendix B – Data-Flow Diagrams.
E N D
Stark & AssociatesHealth Clinic E-R Diagram & Design Project Team Shawn Conatser Madhusudan Gupta ShyamSundarBhelle
Table of Contents • System Concept • Structure Chart • E-R Diagram • Physical Design • Input • Output • Appendix A – Business Background • Appendix B – Data-Flow Diagrams
Physical Design • Patient(Patient_ID, Patient_LastName, Patient_ FirstName, Patient_MaritalStatus, Patient_ DOB, Patient_Gender, Patient_ Address, Patient_Phone, Patient_ Email) • Patient_History(Patient_ID, PHist_Measles, PHist_ Mumps, PHist_ Rubella, PHist_ Chickenpox, PHist_High_BloodPressure, …, PHist_ High_Cholestrol) • Patient_Insurance(Patient_ID, PI_Occupation, PI_Employer, PI_EmployerAddress, PI_EmployerPhone, PI_PrimaryInsurance, PI_GroupNum, PI_PolicyNum) • Appointment(Appoint_ID, Patient_ID, Doctor_ID, Appoint_Date, Appoint_Time, Appoint_Type, Pre_Exam_Height, Pre_Exam_Weight, Pre_Exam_Temp, Pre_Exam_Bloodpressure, Appoint_Symptoms, Appoint_Diagnosis, Appoint_Comments) • Medical_Supply(Supply_ID, Supply_Description, Supply_Price, Supply_Qty_Instock) • Consumed_Supply(Appoint_ID, Supply_ID, Qty_Consumed) • Doctor(Doctor_ID, Doctor_LastName, Doctor_FirstName, Doctor_Address, Doctor_Phone, Doctor_Pager, Doctor_Email, Doctor_DOB, Doctor_Specialization) • Diagnostic_Procedure(Diagnostic_ID, Patient_ID, Doctor_ID, Diagnostic_Date, Diagnostic_Code, Diagnostic_Description, Diagnostic_Result) • Prescription(Presc_ID, Patient_ID, Doctor_ID, Presc_Date, Presc_Medication, Presc_Num_Refills) • Referral(Referral_ID, Patient_ID, Doctor_ID, Referral_Information)
Background • Stark & Associates Health Clinic is a new enterprise that currently schedules patient appointments manually and processes hardcopy patient information • 3 Doctors, 3 Nurses, and 5 Staff Members • On-site Diagnostic Lab
Business Need • This project has been initiated to increase revenue and reduce cost by creating a system that will improve the accuracy and efficiency of patient scheduling and information processing.
Business Requirements • Using the web or in-clinic computers, patients will be able to create an account that will allow them to schedule appointment(s) and provide their information. • Staff will be able to access patient information in order to process appointments and billing. • Nurses and doctors will be able to access patient information, input patient diagnosis, request diagnostic procedures, and generate prescription(s).
System Functionality • Patient account creation and deletion • Allow patient information to be entered and updated • Contact information, medical history, insurance information, and billing information • Appointment scheduling (including confirmation) • Appointment data entry and retrieval • Patient pre-exam information (weight, blood pressure, etc.) entry (nurse/doctor) • Access previous appointment medical information (nurse/doctor) • Patient diagnosis entry (doctor) • Diagnostic procedure requests (nurse/doctor) • Generate prescriptions (doctor)
System Functionality Cont’d • Generate billing invoices • Employee account creation and deletion • Allow employee information to be entered and updated • Contact information • Allow employees to access and update work schedule • Report generation • Billing, salary, diagnostic procedure information, and prescription information
Context Level • Entities • Patient • Employee • Doctor • Nurse • Staff • Diagnostic Lab System • Pharmacy System • Insurance System • Payment Clearing House
Entities Patient Employee Doctor Nurse Staff Diagnostic Lab System Pharmacy System Insurance System Payment Clearing House Processes Profile Processing Scheduling Exam Processing Billing Report Processing Data Stores Patient Data Doctor Data Nurse Data Staff Data Work Schedule Data Appointment Data Medical Supply Inventory Billing Data Invoice Record Level 0
Level 1 – Exam Processing Entities Patient Doctor Nurse Staff Diagnostic Lab System Pharmacy System Processes Process Pre-Exam Information Process Exam Information Process Post-Exam Information Data Stores Patient Data Medical Supply Inventory
Level 1 - Billing Entities Patient Staff Insurance System Payment Clearing House Processes Determine Total Due Process Payment Record Payment Data Stores Patient Data Billing Data Invoice Record
Level 2 – Determine Total Due Entities Patient Staff Insurance System Processes Determine Supply Total Determine Diagnostic Total Determine Exam Total Data Stores Patient Data Medical Supply Inventory Billing Data