Entity Relationship Diagram Example: MIS


An ER diagram is a pictorial representation of the information that can be captured by a database. This is an ER diagram example that shows the major entities within an MIS, which include employee, department, project and department. There are columns for each entity that indicate their properties.

Use this ER diagram template to get started building your own. Customize the ER diagram to reflect the objects of your problem. Click Use this Template to start.

What is Entity Relationship Diagram?

The ERD was introduced by Chen (1976) in early 1976. An ERD can be served as the basis for databases, which store data about the problem domain, and which use, manipulate, and constrain that data. Experts in systems analysis and database design are adept at identifying user requirements and then translating them into corresponding components of the model. The entity relationship diagram is a graphical representation of a conceptual structure of a problem domain being modeled. The ERD assists the database designer in identifying the data and the rules that will be represented and used in a database.

Benefits of ER diagrams

  1. Easy to understand and do not require a person to undergo extensive training to be able to work with it efficiently and accurately
  2. Easily communicate with developers, customers, and end users, regardless of their IT proficiency.
  3. Readily translatable into relational tables which can be used to quickly build databases.
  4. Can directly be used by database developers as the blueprint for implementing data in specific software applications.
  5. May be applied in other contexts such as describing the different relationships and operations within an organization.

Keen to try VP Online?

No limitations, no obligations, no cancellation fees.

Start a Free Trial

We use cookies to offer you a better experience. By visiting our website, you agree to the use of cookies as described in our Cookie Policy.