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

You are viewing 1/3rd of the document.
Purchase the document to get full access instantly.

Immediately available after payment
Both online and downloadable
No strings attached

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.