Homework $($Entity$-$Relationship Diagram$)$

Objective: $(1)$ Practice database modeling; $(2)$ Get familiar with Visual Paradigm.

Problem description:

We are modeling a medical records database for a clinic. The following story describes

the entities and their relationships in our clinic:

For each patient, there is an ID$,$ name, age. We also need to maintain the patient$$s medical

history before they joined the clinic. The medical history includes information on their

previous illnesses, as well as$,$ their vaccination record. The vaccination record includes

the date and the place the vaccine is given, the name and the quantity of vaccine. For each

vaccine, there is a unique id$,$ name, and producer.

For each physician, there is an ID$,$ name, and specialty. We also need to keep track of

each visit: Who the patient is$,$ who the attending doctor is$,$ and the date of the visit. For

each visit, we also need to know: the medications prescribed and their dosage, tests

ordered and the results of those tests, and the doctor$$s notes about the visit.

Use Visual Paradigm to draw the ERD for the database model that you come up with for

this clinic. Your diagram should show entities and their attributes, primary keys, and

connecting relationships. Use three Normal Form rules to examine your tables to make

sure they satisfy all three Normal Forms. Also, please resolve all m$-$n relationships into

$1$m or $1-1$ relationships.

Note:

$$ For each time of vaccination, more than one vaccines could be given;

$$ For each visit, $0$ or more medicines could be prescribed, and $0$ or more tests could

be ordered

$$ Please pick ERD diagram, not class diagram form Visual Paradigm. Here is an

example of an ERD diagram.