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.

  • yes it is, I am a beginner
    – Sagar
    Sep 12, 2017 at 23:40
  • i dont want an answer but just a guidance on how can I solve the problems like this?
    – Sagar
    Sep 12, 2017 at 23:46
  • See my answere here - particularly the bit about Googling Open Source software!
    – Vérace
    Sep 13, 2017 at 4:13


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.