E R Diagram To Relational Schema Develop A Logical Database Design Relational Schema 2794590

E-R Diagram to Relational schema.

Develop a logical database design (relational schema) for theconceptual data model shown at the end of this document. Allrelations in your logical database design should be normalized tothe third Normal form (3NF).

Use arrows to show referential integrity constraints. You don’thave to show the functional dependencies among the attributeswithin a relation (table), but you have to make sure that all yourrelations are normalized to the 3NF.

A possible solution for IDS QUALIFICATION 410 HOMEWORK #1 Note An attribute with double underlinesmeans that it is part of a composite identifier QualificationNo STAFF Q_Type Q Date Institution Staff No Name Address Phone WARD Ward No Ward Name Location Phone Ext NumOfBed STAFF_ALLOCATION WORK EXPERIENCE Has AllocationDate Shift ExperienceNo StartDate FinishDate Organization Position In Charge of WARD REQUISITION PATIENT APPOINTMENT Submits ALLOCATION CLINIC APPOINTMENT Req No Req Date PatientAllocNo DatePlaced BedNo OnWaitingList ExpectedStay ExpectedLeave ActualLeave AppointmentDate AppointmentTime RoomNo Results Date Time REQUEST LINE LOCAL Quantity DOCTOR DoctorlD Name ClinicNo Address Phone PATIENT Refers SUPPLIER SuppNo SuppName SuppAddr SuppPhone SuppFax HOSPITAL PRICE QUOTE SUPPLIES SuppliesNo Name Description Unit Cost On Hand ReorderLevel UnitCost Has NEXT-OF-KIN Address Relationship Phone PHARMACEUTICAL PATIENT MEDICATION StartDate FinishDate UnitPerDay SUPPLIES 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

A possible solution for IDS QUALIFICATION 410 HOMEWORK #1 Note An attribute with double underlinesmeans that it is part of a composite identifier QualificationNo STAFF Q_Type Q Date Institution Staff No Name Address Phone WARD Ward No Ward Name Location Phone Ext NumOfBed STAFF_ALLOCATION WORK EXPERIENCE Has AllocationDate Shift ExperienceNo StartDate FinishDate Organization Position In Charge of WARD REQUISITION PATIENT APPOINTMENT Submits ALLOCATION CLINIC APPOINTMENT Req No Req Date PatientAllocNo DatePlaced BedNo OnWaitingList ExpectedStay ExpectedLeave ActualLeave AppointmentDate AppointmentTime RoomNo Results Date Time REQUEST LINE LOCAL Quantity DOCTOR DoctorlD Name ClinicNo Address Phone PATIENT Refers SUPPLIER SuppNo SuppName SuppAddr SuppPhone SuppFax HOSPITAL PRICE QUOTE SUPPLIES SuppliesNo Name Description Unit Cost On Hand ReorderLevel UnitCost Has NEXT-OF-KIN Address Relationship Phone PHARMACEUTICAL PATIENT MEDICATION StartDate FinishDate UnitPerDay SUPPLIES 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

Prof. Angela

4.6/5

Calculate Price


Price (USD)
$