I have to develop an entity-relationship diagram (ERD) for a business domain with the following characteristics:
A doctor consults from one clinic only, but a clinic may have many doctors working from it.
A patient makes an appointment to see a doctor on a specific day and time.
A patient may consult with many doctors and a doctor must consult with at least one patient.
My current work
I've been able to create the following diagram:
Note: I am a beginner and have just the base knowledge.