Use MYSQL Workbench to create EER diagram for a database $($namely yournetid$\_$WellnessClinic$\_$db$)$ that stores information of the Patients, Doctors $,$ Appointment details and Patient Visit Files. Apply forward engineer and generate script to create the tables. Show the diagram also.

Consider the following information and provide the appropriate DDL statements to create each table. Identify and define Primary keys and Foreign keys in all the table and add necessary constraints. Define all kinds of relationship between the tables possible.

Don$$t have to insert data into these tables.

Patient Table contains the list of patients, their Contact Information and Insurance Information

Name

Email Address

Physical Address

Phone number

Emergency contact

Insurance Provider

Doctor Table contains the list of doctors in the Clinic their Contact information their specialization and locations available.

Name

Email

Locations

Phone number

Specialization

Appointment Table contains the details of the scheduled appointments that patient makes to see a doctor.

Date

Time

Patient

Doctor

Location

Patient Files Table contains the interaction details that happens between Doctor and Patient on an appointment day

Doctor Notes

Date

Time

Patient Notes$/$Problems Treatment suggested

medications prescribed