Entity Relationship Diagram Example: Student Score - Binary Relationship

Description:

ER diagrams symbolically shows the entities of a system and their inter-relationships. This is an ERD that shows the use of binary relationship in ERD.

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 ER Diagram?

An entity relationship diagram (also known as ER model or ER diagram in short) describes interrelated things of interest in a specific domain of knowledge. An ER diagram is usually the result of systematic analysis to define and describe what is important to processes in an area of a business. It does not define the business processes; it only presents a business data schema in graphical form. It is usually drawn in a graphical form as entities that are connected by relationships which express the associations and dependencies between entities.

Conceptual Design vs Logical Design vs Physical Design ERD

Conceptual Database Design produces the initial model of the mini world in a conceptual data model similar to the Entity-Relationship-Model).

Logical Database Design transforms this schema into the data model supported by the DBMS to be used similar to the relational model.

Physical Database Design aims at improving the performance of the final database system.

During conceptual design, we should focus is on producing a correct model of the real world. There is no need to worry about performance aspects or limitations of a specific DBMS.

Keen to try VP Online?

No limitations, no obligations, no cancellation fees.


Start a Free Trial