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: