Download as:
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Language:EN
Pages: 2

Many tests and many treatments the hospital

Draw ER/EER diagram for the following entities:
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.

Note: use Dia tool or Visio to draw the diagram.

(5) Primary key identification

PART 2:

1.check if you have connected the Entities right, mentioned
the Relationships, Cardinality constraints (not just 1 or many, you should mention whether its optional or mandatory, min/max), Primary key, Foreign key & Attributes with its types (adding new attributes for needed entities & mentioning its type is encouraged).

2.For EER Diagram, subtypes & supertypes must be mentioned.

7.You should give a brief description of what changes you have made to your diagram in the conversion process(from ER to EER) so that I can understand your idea.

PART 3:

Copyright © 2009-2023 UrgentHomework.com, All right reserved.