Stark

1
Stark AssociatesHealth Clinic

• E-R Diagram Design
• Project Team
• Shawn Conatser
• Madhusudan Gupta
• Shyam Sundar Bhelle

2
Table of Contents

• System Concept
• Structure Chart
• E-R Diagram
• Physical Design
• Input
• Output
• Appendix A Business Background
• Appendix B Data-Flow Diagrams

3
System Concept
4
Structure Chart
5
E-R Diagram
6
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)

7
Input Patient Information
8
Output Billing Statement
9
Questions

• ?

10
Appendix ABusiness Background
11
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

12
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.

13
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).

14
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)

15
System Functionality Contd

• 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

16
Appendix BData-Flow Diagrams
17
Context Level

• Entities
• Patient
• Employee
• Doctor
• Nurse
• Staff
• Diagnostic Lab System
• Pharmacy System
• Insurance System
• Payment Clearing House

18
Context Diagram
19
Level 0

• 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

20
Level 0 Diagram
21
Level 0 Diagram continued
22
Level 0 Diagram continued
23
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

24
Level 1 Diagram Exam Processing
25
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

26
Level 1 Diagram Billing
27
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

28
Level 2 Diagram Determine Total Due