An ERD for a Patient Admission System
An ERD (Entity Relationship Diagram) shows the relationships between entities in a database. Entities are data components found within a database. An Entity Relationship Diagram illustrates a logical database structure and resembles a flowchart, with the only difference being the specialized symbols making up its structure. Rectangles represent entities, the diamond shapes represent relationships between the entities, while ovals represent attributes that are the characteristics or distinguishing features of the entities. The entities are connected through solid lines which show the relationships. Cardinality shows the number of instances one entity relates to another and specifies the maximum number of relationships. Figure 1 below illustrates an entity relationship diagram for a patient’s admission system.
Figure 1
Entity Relationship Diagram
ERD for the Patient Admission System
References
Chen, P. (2006). The entity-relationship model – Toward a unified view of data. ACM Transactions on Database Systems, 1(1).
ORDER A PLAGIARISM-FREE PAPER HERE
We’ll write everything from scratch
Question 
An ERD for a Patient Admission System
Based on the readings and your research, draw an entity relationship diagram (ERD) for a patient admission system given the following:
An ERD for a Patient Admission System
- Whenever new patients are seen for the first time, they complete a patient information form that asks their name, address, phone number, and insurance carrier, all of which are stored in the patient information file.
- Patients can be signed up with only one carrier, but they must be signed up to be seen by the doctor.
- Each time a patient visits the doctor, an insurance claim is sent to the carrier for payment.
- The claim must contain information about the visit, such as the date, purpose, and cost. It would be possible for a patient to submit two claims on the same day. Use MS Visio to create the diagrams, copy and paste into a MS word document.