Question: Can i get a data schema for this EER diagram the diagram is shared in two images for more clarity. Doctor Nurse Patient assigns PK

Can i get a data schema for this EER diagram the diagram is shared in two images for more clarity.

Can i get a data schema for this EER diagram theCan i get a data schema for this EER diagram the

Doctor Nurse Patient assigns PK Nurse ID Admin Staff FK Staff ID Name Provides Information -Treats/Cares for- PK Patient Registration no. Name PK Doctor ID Department Specialty Name Address Phone # Staff Name Phone # PK StaffID Age Address Name Registers Patient Gender Room H Staff Type Gender + Phone # PK Room # Phone # I 1 Phone No. Salary Registration Desk Medical History Room Type Medical Condition FK Medical Fille # Patient FK Registration # Name Date >Maintains Staff Type Belongs To Patient Type Age Nurse Maintenance Inpatient Phone # Department Administration EK Maintenance Staff ID FK Room # Medical History Outpatient Prescription Code FK PK Admin Pass Date Admitted PK Dept Name Specialty Location Type Date of Visit Medical Diagnosis Prescription Code FK Doctor ID ICU Operating Room Ward FK Consultation Room Rooms Has Patient Medical File Has PK Medical File # Date Name Medical History Diagnosis Lab Results Prescription Prescription PK Code Patient Name Medications Drug Name Directions Prescriptions Expiration date Querys Prescription Pharmacy Technician Fills & Dispense Prescription PharmlD FK Admin Pass Name Fills & Dispense Prescription

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!