Question: PLEASE A database system for the Elijah Community Hospital would have many tables. Draw ER/EER diagram for the following entities: (using the shapes *square, diamond,
PLEASE
A database system for the Elijah Community Hospital would have many tables. Draw ER/EER diagram for the following entities: (using the shapes *square, diamond, oval*) PATIENT: PatientID, Name, DOB, Age, Gender, Address, Email, Phone (one or two) BED: BedNumber, PatientID PERSONNEL: PersonnelID, Name, Phone, Email (one or two), Address, Hire-date, Position DEPARTMENT: DepartmentCode, DepartmentName TREATMENT: TreatmentCode, TreatmentDescription, TreatmentCost TEST: TestCode, TestDescription, TestCost Add new attributes to several of your entities if there is a need.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
