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.

QUALICATION Entity Relationship Diagra for Lakeshore Hospital Note: 1 atbute the underines was the part of a computer WARD ad_NO ITAFFALLOCATON Ward Name Location tocante Phone_b BMT NumOfBed STAFF statt Me Name Jouel carton o. retu POHH_EEPEATERS Phone 04 Solo FinishDate Organization Position Submit WARD 0 REQUISITION Beg_NO Req_Oate PATENT ALLOCATION PAMAC Depuced Bed No Omating at Expected Stay Expech dleave Adualle in charge or APPOINTMENT pointment Appointment Date Appormer Time Room NO Results CLINIC APPOINTMENT Date Time REQUEST_LINE Quantity PATIENT Patent -Retr LOCAL DOCTOR DOCEDIR Name CinioNO Address phone SUPPLIER NO SuppName Supper SuppPhone SuppFax HOSPITAL PRICE_QUOTE GUPPLE +04 > SIGN URS Name Descripton Unt_com on_Hand Reorder Level Has NEXT-OP-KIN OH padre Relationship Phone PATIENT_MEDICATION Start inshose O Unt PerDay E PHARMACEUTICAL SUPPLIES Dosage Adminivethod Adatonai rutes to STAFF and PATIENT STAFF DOB.O.TQT), Schey PATIENT: Adites, Pere. Dender, DOB. St. Reestered Date