Patient Management System ER diagram

 Patient Management System ER Diagram

This ER diagram represents the model of Patient  management system entity. The entity relationship diagram of Patient management system allows all the visual instrument of database tables and the relational between structured data groups of Patient management system functionalities.

Let’s start from the symbols used in the ER Diagram.

Entity is represented by the rectangle shape. The entity will be our database table of Patient Management System later on.

Attribute is represented by the oval shape. This will be the columns or fields of each table in the Patient Management System.

Relationship is represented by diamond shape. This will determine the relationships among entities. This is usually in a form of primary key to foreign key connection.

Step 1: The first step is to identify the entity sets. As per your requirement, you will have some main entities. For example, if you require to observe which patient goes to which hospital or whether they have a previous record or not, or if you simply want to analyze the number of patients a doctor treats, then your main entities will be as follows:

• Hospital
• Patient
• Medical Record
• Doctor

Step 2: The second step is to map out the attributes of the entities. In this case, the attributes will be as follows:

• Hospital: Hospital ID, city, address, name, patient ID, and doctor ID.
• Patient: Patients’ ID, patient’s name, address, diagnosis, record ID, and hospital ID
• Medical Record: Record ID, problem, date of examination, and patient ID.
• Doctor: Doctor ID, name, qualification, salary, and hospital ID.

Then identify the key attributes. For the above example, they will be hospital ID, patients ID, record ID, and doctor ID.

Step 3: Identify the type of relationship that exists between the entities. This can be done by identifying primary and foreign keys.

For example, if the hospital table makes a foreign key reference to the patient ID of the patient table, then both of them will be joined together. Based on the cardinalities, you have to place the appropriate sign.

Step 4: Once you have identified all the relationships, it is time to map out the lines.

• Since a hospital has multiple patients, thus it is a one-to-many relationship.
• Since a single hospital has many doctors, the relationship that exists is one-to-many.
• Since a doctor is associated with many patients, it is a one-to-many relationship.
• Since a single patient has multiple medical records, thus it is a one-to-many relationship.

Step 5: The last step is to combine all the relationships and draw a complete ER diagram. The final look will be as follows: