ERD.jpg

<div>
<div class="content wysiwyg-content">
Hi, I'm trying to draw an Entity Relationship Diagram for a smal General Practitioner's clinic. <br />
<br />
A patient can see many doctors<br />
A doctor can see many patients<br />
A patient/doctor has 1 or more appointments<br />
An appointment issues an invoice<br />
A doctor prescribes a prescription<br />
A patient has one record<br />
A record consists of many appointments<br />
<br />
Please can you take a look to see if I am displaying this correctly in my diagram. I am a bit unsure about how to involve the Prescription entity <a href="https://filedb.experts-exchange.com/incoming/2011/03_w13/436907/ERD.jpg" target="_blank" title="Erd diagram (43 KB)"><img alt="Erd diagram" class="file-block lazyload" style="max-width: 739px;" data-src="https://filedb.experts-exchange.com/incoming/2011/03_w13/436907/ERD.jpg" /></a>
</div>
</div>


Hi, I'm trying to draw an Entity Relationship Diagram for a smal General Practitioner's clinic. 

A patient can see many doctors
A doctor can see many patients
A patient/doctor has 1 or more appointments
An appointment issues an invoice
A doctor prescribes a prescription
A patient has one record
A record consists of many appointments

Please can you take a look to see if I am displaying this correctly in my diagram. I am a bit unsure about how to involve the Prescription entity 

ERD diagram needs verification

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.