1. Convert the Entities in the below diagram into tables and the relations into keys. Your relations should be normalized to the third Normal form
Note: You need to indicate referential integrity links between tables by drawing arrows from the Foreign Key to the Primary Key of the respective Entities (Tables)Use arrows to show referential integrity constraints. You dont have to show the functional dependencies among the attributes within a relation(table).
QUALIFICATION QualificationNo Note An attribute with double underlines means that it is part of a composite primary key STAFF Has Q_Type Q Date Institution WARD Name Address Phone Ward No Ward_Name Location Phone Ext NumOfBed STAFF_ALLOCATION WORK_EXPERIENCE AllocationDate as ExperienceNo StartDate FinishDate Organization Position hift In Charge o WARD PATIENT ALLOCATION APPOINTMENT Submit REQUISITION in CLINIC APPOINTMENT Req No Req Date AppointmentDate AppointmentTime RoomNo Results DatePlaced BedNO OnWaitingList ExpectedStay ExpectedLeave ActualLeave Date Time REQUEST LINE LOCAL Quantity DOCTOR DoctoriD PATIENT PatientNo Refe Name ClinicNo Address Phone SUPPLIER SuppNo SuppName SuppAddr SuppPhone SuppFax HOSPITAL PRICE QUOTE SUPPLIES UnitCost Name Description Unit_Cost On Hand ReorderLevel Has NEXT-OF-KIN Name Address Relationship Phone PHARMACEUTICAL SUPPLIES PATIENT MEDICATION StartDate FinishDate UnitPerDay Dossage AdminMethod Additional attributes for entities STAFF and PATIENT STAFF: DOB, Sex, NIN, Position_Held, Current Salary, Current Scale, Contract Type, Payment Type, Hours PATIENT: First_Name, Last_Name, Address, Phone, Gender, DOB, Status, Registered Date QUALIFICATION QualificationNo Note An attribute with double underlines means that it is part of a composite primary key STAFF Has Q_Type Q Date Institution WARD Name Address Phone Ward No Ward_Name Location Phone Ext NumOfBed STAFF_ALLOCATION WORK_EXPERIENCE AllocationDate as ExperienceNo StartDate FinishDate Organization Position hift In Charge o WARD PATIENT ALLOCATION APPOINTMENT Submit REQUISITION in CLINIC APPOINTMENT Req No Req Date AppointmentDate AppointmentTime RoomNo Results DatePlaced BedNO OnWaitingList ExpectedStay ExpectedLeave ActualLeave Date Time REQUEST LINE LOCAL Quantity DOCTOR DoctoriD PATIENT PatientNo Refe Name ClinicNo Address Phone SUPPLIER SuppNo SuppName SuppAddr SuppPhone SuppFax HOSPITAL PRICE QUOTE SUPPLIES UnitCost Name Description Unit_Cost On Hand ReorderLevel Has NEXT-OF-KIN Name Address Relationship Phone PHARMACEUTICAL SUPPLIES PATIENT MEDICATION StartDate FinishDate UnitPerDay Dossage AdminMethod Additional attributes for entities STAFF and PATIENT STAFF: DOB, Sex, NIN, Position_Held, Current Salary, Current Scale, Contract Type, Payment Type, Hours PATIENT: First_Name, Last_Name, Address, Phone, Gender, DOB, Status, Registered Date
