Question: Can i get a data schema for this EER diagram Doctor Nurse assigns PK Nurse ID Name Phone # M TreatsiCares for PK Staff PK

Can i get a data schema for this EER diagram

Can i get a data schema for this EER diagram

Doctor Nurse assigns PK Nurse ID Name Phone # M TreatsiCares for PK Staff PK Doctor ID Department Specialty Name Address Gender Phone# Salary + PK StaffID Name Stall Type Phone # Patient Admin Staff Patient Provides +FK Staff ID Registration no. information Name Name Phone # Age Address Register's Patient Gender Phone No. Registration Desk Medical History FK Medical Fille # Room + PK Room # Room Type Medical Condition Date FK Patient >Maintains Belongs To Staff Type Patient Type Registration Name Age Phone #1 Nurse Maintenance FK Staff ID Inpatient Maintenance Administration Medical History PK Admin Pass FK Department PK Dept Name Specialty Location FK Doctor ID Outpatient Prescription Code Date of Visit Type FK Room Date Admitted Medical Dlagnosis EK Prescription Code v ICU Operating Room Ward Consultation Rooms Has Has Patient Medical File PK Medical File # Date Name Medical History Diagnosis Lab Results Medications Prescriptions Prescription PK Prescription Code Patient Name Drug Name Directions Expiration date Querys Prescription- Fills & Dispense Prescription Pharmacy Technician PK PharmiD FK Admin Pass Name Fills & Dispense Prescription Doctor Nurse assigns PK Nurse ID Name Phone # M TreatsiCares for PK Staff PK Doctor ID Department Specialty Name Address Gender Phone# Salary + PK StaffID Name Stall Type Phone # Patient Admin Staff Patient Provides +FK Staff ID Registration no. information Name Name Phone # Age Address Register's Patient Gender Phone No. Registration Desk Medical History FK Medical Fille # Room + PK Room # Room Type Medical Condition Date FK Patient >Maintains Belongs To Staff Type Patient Type Registration Name Age Phone #1 Nurse Maintenance FK Staff ID Inpatient Maintenance Administration Medical History PK Admin Pass FK Department PK Dept Name Specialty Location FK Doctor ID Outpatient Prescription Code Date of Visit Type FK Room Date Admitted Medical Dlagnosis EK Prescription Code v ICU Operating Room Ward Consultation Rooms Has Has Patient Medical File PK Medical File # Date Name Medical History Diagnosis Lab Results Medications Prescriptions Prescription PK Prescription Code Patient Name Drug Name Directions Expiration date Querys Prescription- Fills & Dispense Prescription Pharmacy Technician PK PharmiD 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!