After your data modeling is complete, it is possible to create an Entity Diagram, which allows to have a full picture of your data modeling.
#10 – Add an Entity Diagram
#11 -Drag and Drop entities into Diagram
Using a Veterinary Clinic as an example, we will define an Entity Relationship Diagram representing the business needs.
In this scenario, the Veterinary Clinic schedules health appointments with different purposes, like a Routine consult or an Urgency (Consultation Type – Static Entity). The consultation is led by a Vet who diagnoses the Pet’s general health and prescribes a treatment. For each consultation, it is also possible to proceed with several exams and assign the results.
Each Pet is associated with only one owner (Customer), and besides the usual attributes, it is possible to define the Gender of the Pet, like Female, Male, or Undefined.
#12 -Veterinary Clinic Entity Diagram