Entity Relationship Model - SENG-350-2024-fall/Team4 GitHub Wiki

Entity Relationship Diagram

The Entity Relationship Diagram (ERD) for the Mister Ed Medical Information System represents the system's data structure visually. Identify and define the system's key entities, attributes, and relationships. The diagram is crucial for understanding how the system's data is structured and how the different entities interact with one another. It's helpfull for clarifying the system's functionality, including how data flows through the various components and how the entities are interrelated.

Diagrams Explanation

1. Patient to Virtual Triage:

   • Relationship Name: "Undergoes"
   • Relationship Type: One-to-Many
   • Description: Each patient can undergo multiple virtual triage sessions within the system. This relationship ensures that the system can track a patient’s multiple virtual assessments and provide doctors with data to review. It can be read as "A Patient undergoes multiple Virtual Triages" or "A Virtual Triage is undergone by a Patient."

2. Patient to Appointment:

   • Relationship Name: "Books"
   • Relationship Type: One-to-Many
   • Description: A single patient can book multiple appointments. This is essential for managing patients' schedules and ensuring they can visit different facilities or specialists as needed. It can be read as "A Patient books multiple Appointments" or "An Appointment is booked by a Patient."

3. Doctor to Virtual Triage:

   • Relationship Name: "Reviews"
   • Relationship Type: One-to-Many
   • Description: Doctors review multiple virtual triage results submitted by patients. This allows the doctor to assess the patient's condition before making further recommendations. It can be interpreted as "A Doctor reviews multiple Virtual Triage results" or "A Virtual Triage is reviewed by a Doctor."

4. Doctor to Appointment:

   • Relationship Name: "Monitors"
   • Relationship Type: One-to-Many
   • Description: A doctor can monitor multiple patient appointments, allowing them to keep track of which patients they need to follow up with in person. It can be read as "A Doctor monitors multiple Appointments" or "An Appointment is monitored by a Doctor."

5. Nurse to Patient:

   • Relationship Name: "Manages"
   • Relationship Type: One-to-Many
   • Description: Nurses manage the details of multiple patients, handling their virtual triage results, scheduling follow-ups, and updating their medical information. It can be interpreted as "A Nurse manages several Patients" or "A Patient is managed by a Nurse."

6. Nurse to Appointment:

   • Relationship Name: "Schedules"
   • Relationship Type: One-to-Many
   • Description: Nurses schedule follow-up appointments for multiple patients based on the results of their virtual triage. It can be read as "A Nurse schedules many Follow-up Appointments" or "A Follow-up Appointment is scheduled by a Nurse."

7. System Admin to Facility:

   • Relationship Name: "Manages"
   • Relationship Type: One-to-Many
   • Description: A system admin manages several healthcare facilities, adding or modifying their details within the system. This ensures proper management and availability of healthcare resources. It can be read as "A System Admin manages multiple Facilities" or "A Facility is managed by a System Admin."

8. Facility to Appointment:

   • Relationship Name: "Handles"
   • Relationship Type: One-to-Many
   • Description: A facility handles multiple appointments for different patients. This relationship ensures that each facility's scheduling system is kept up-to-date and resource management is optimized. It can be read as "A Facility handles several Appointments" or "An Appointment is handled by a Facility."

9. Patient to Notifications:

   • Relationship Name: "Receives"
   • Relationship Type: One-to-Many
   • Description: Patients receive multiple notifications about their appointments, triage results, and other system updates. The system ensures patients are kept informed about their healthcare journey. It can be read as "A Patient receives multiple Notifications" or "A Notification is received by a Patient."

10. Follow-up Appointments to Doctor and Nurse:

    • Relationship Name: "Scheduled By"
    • Relationship Type: One-to-Many (with Nurse) and One-to-One (with Doctor)
    • Description: Follow-up appointments are scheduled by nurses for multiple patients, and each appointment is assigned to a specific doctor. This ensures that the correct doctor sees the patient based on the triage results. It can be interpreted as "A Follow-up Appointment is scheduled by a Nurse and assigned to a Doctor."