Question: Please answer the question for the diagram as it is different from the other one posted on chegg. I've posted this question twice now. Draw

Please answer the question for the diagram as it is different from the other one posted on chegg. I've posted this question twice now.

Draw your Relational Schema based on the following Entity Relationship Diagram (conceptual data model) on the second page. Your relations should be normalized to the third Normal form (3NF). Be sure to use arrows from the foreign keys to their corresponding primary keys to show the referential integrity constraints

Please answer the question for the diagram as it

Entity Relationship Diagram for Lakeshore Hospital Has Note: An attribute wth double underlines means that it is part of a composite identiter WARD Ward_NO STAFF Staff No Name Address QUALIACATION Quel culong O_T _ Der irsuton STAFF_ALLOCATION WORK EXPERIENCE tocation Ward Name AlocationDate Alth Phone Haso experience no Shit Phone_Eat NumOfBed StartDate FinishDate Organization Position WARD Submits REQUISITION THEa Ng. CLINIC APPOINTMENT -n Charge 01- APPOINTMENT Appointment. No + Appointment Time Room No Results PATIENT ALLOCATION Patient AllocNO Date Placed Bed No Onwaiting Ust Expected Stay Expected Leave ActualLeave Req_Date Date Time LOCAL DOCTOR Doctorio REQUEST_LINE DO Quantity PATIENT Patent No Reters Name th Clinic No Address Phone SUPPLIER SuppNO SuppName SuppAddr Supp Phone SuppFax PRICE_QUOTE 04 Unttoos HOSPITAL SUPPLIES t th supplies No Name Description Unit_003 On_Hand Reorder Level Has NEXT-OF-KIN Name OH Address Relationship Phone PHARMACEUTICAL BUPPLIES PATIENT_MEDICATION Start Date Finish Date Unit PerDay Do ssage Admin Method Additional attributes for entities STAFF and PATIENT STAFF: DOB, Cerder, TobTth, Sabry PATIENT: Name, Address, Prore, Gender, DOB, Stats, Registered Date Entity Relationship Diagram for Lakeshore Hospital Has Note: An attribute wth double underlines means that it is part of a composite identiter WARD Ward_NO STAFF Staff No Name Address QUALIACATION Quel culong O_T _ Der irsuton STAFF_ALLOCATION WORK EXPERIENCE tocation Ward Name AlocationDate Alth Phone Haso experience no Shit Phone_Eat NumOfBed StartDate FinishDate Organization Position WARD Submits REQUISITION THEa Ng. CLINIC APPOINTMENT -n Charge 01- APPOINTMENT Appointment. No + Appointment Time Room No Results PATIENT ALLOCATION Patient AllocNO Date Placed Bed No Onwaiting Ust Expected Stay Expected Leave ActualLeave Req_Date Date Time LOCAL DOCTOR Doctorio REQUEST_LINE DO Quantity PATIENT Patent No Reters Name th Clinic No Address Phone SUPPLIER SuppNO SuppName SuppAddr Supp Phone SuppFax PRICE_QUOTE 04 Unttoos HOSPITAL SUPPLIES t th supplies No Name Description Unit_003 On_Hand Reorder Level Has NEXT-OF-KIN Name OH Address Relationship Phone PHARMACEUTICAL BUPPLIES PATIENT_MEDICATION Start Date Finish Date Unit PerDay Do ssage Admin Method Additional attributes for entities STAFF and PATIENT STAFF: DOB, Cerder, TobTth, Sabry PATIENT: Name, Address, Prore, Gender, DOB, Stats, Registered Date

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!