Draw an ERR diagram with this information: EER Diagram for Royal Victoria Hospital Information System Assumptions: The diagram focuses on the entities and relationships. Attributes with cardinality are assumed to be single-valued. Dates are assumed as identifiers for visits. Entities: Person: (person_ID, name, address, birth_date, phone_number) Employee: (inherits from Person, date_hired) Nurse: (inherits from Employee, certificate) Staff: (inherits from Employee, job_class) Technician: (inherits from Employee, skill) Physician: (inherits from Person, speciality, pager_number) Patient: (inherits from Person, contact_date, resident_flag) Outpatient: (inherits from Patient) Resident: (inherits from Patient) Visit: (date, comments, outpatient_ID) Care Centre: (name, location) Laboratory: (name, location) Bed: (bed_number, room_number, care_centre_ID) Item: (item_number, description, unit_cost) Treatment: (treatment_ID, treatment_number, treatment_name) Consumption: (patient_ID, item_ID, date, time, quantity, total_cost) Relationships: Employs: (1:N; Person --> Employee) Is Physician: (1:N; Person --> Physician) Is Patient: (1:N; Person --> Patient) Is Volunteer: (N:M; Person <-- Volunteer) Admits: (1:N; Physician --> Patient) Refers: (1:N; Physician --> Patient) Performs: (N:M; Physician <-- Treatment --> Patient) Has Visit: (1:N; Outpatient --> Visit) Assigns Nurse to: (N:M; Care Centre <-- Nurse) Appoints Nurse-in-Charge: (1:1; Care Centre --> Nurse) Has Employee Work in: (N:M; Employee <-- WorksIn --> Care Centre) Assigns Physician to: (N:M; Care Centre <-- Physician) Has Technician Assigned to: (N:M; Laboratory <-- Technician) Has Bed Assigned to: (N:M; Care Centre <-- Bed) Consumes: (N:M; Patient <-- Consumes --> Item) Records: (N:M; Treatment <-- Records --> Consumption) Explanation: An information system is created that tracks patients, treatments, and supplies to improve hospital operations and patient care.
Draw an ERR diagram with this information:
EER Diagram for Royal Victoria Hospital Information System
Assumptions:
-
The diagram focuses on the entities and relationships.
-
Attributes with cardinality are assumed to be single-valued.
-
Dates are assumed as identifiers for visits.
Entities:
-
Person: (person_ID, name, address, birth_date, phone_number)
-
Employee: (inherits from Person, date_hired)
-
Nurse: (inherits from Employee, certificate)
-
Staff: (inherits from Employee, job_class)
-
Technician: (inherits from Employee, skill)
-
-
Physician: (inherits from Person, speciality, pager_number)
-
Patient: (inherits from Person, contact_date, resident_flag)
-
Outpatient: (inherits from Patient)
-
Resident: (inherits from Patient)
-
-
Visit: (date, comments, outpatient_ID)
-
Care Centre: (name, location)
-
Laboratory: (name, location)
-
Bed: (bed_number, room_number, care_centre_ID)
-
Item: (item_number, description, unit_cost)
-
Treatment: (treatment_ID, treatment_number, treatment_name)
-
Consumption: (patient_ID, item_ID, date, time, quantity, total_cost)
Relationships:
-
Employs: (1:N; Person --> Employee)
-
Is Physician: (1:N; Person --> Physician)
-
Is Patient: (1:N; Person --> Patient)
-
Is Volunteer: (N:M; Person <-- Volunteer)
-
Admits: (1:N; Physician --> Patient)
-
Refers: (1:N; Physician --> Patient)
-
Performs: (N:M; Physician <-- Treatment --> Patient)
-
Has Visit: (1:N; Outpatient --> Visit)
-
Assigns Nurse to: (N:M; Care Centre <-- Nurse)
-
Appoints Nurse-in-Charge: (1:1; Care Centre --> Nurse)
-
Has Employee Work in: (N:M; Employee <-- WorksIn --> Care Centre)
-
Assigns Physician to: (N:M; Care Centre <-- Physician)
-
Has Technician Assigned to: (N:M; Laboratory <-- Technician)
-
Has Bed Assigned to: (N:M; Care Centre <-- Bed)
-
Consumes: (N:M; Patient <-- Consumes --> Item)
-
Records: (N:M; Treatment <-- Records --> Consumption)
An information system is created that tracks patients, treatments, and supplies to improve hospital operations and patient care.
Step by step
Solved in 4 steps with 1 images