Create an ER diagram using Visio based on information below OR Week 3: Create a draft database design using MS Visio using a Conceptual Visio Drawing

PRIMARY KEY

Doctor ID, Patient ID, Procedure ID, Appointment ID

DATA TYPE ENTITY

Doctor: Name of the doctor, Doctor ID. DEA number, and specialty

Patient: Last Name, First Name, Address, Email, Phone, DOB, Insurance ID, Sex, and Employer, and Emergency Contact.

Procedure: Doctor ID, Procedure ID, Patient ID, and Treatment ID.

Appointment: Patient ID, Doctor ID, Date, and Time.