A small surgery center needs your help to create a database. The office manager has identified the following types of data (entities): patients, doctors, procedures, and appointments using the following business rules:
- Patients can have many doctors and many doctors can see many patients.
- Patients can have many procedures and many procedures are done on patients.
- Doctors can have multiple appointments.
(hint: these are many to many relationships, so associative tables need to be added).