ER Model in DBMS

ER Model

[{"selector":"#anim-6ab072e6-9abc-4ef6-9507-a4db5ac1fcab","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-f9aec25c-ae5c-49ad-b1ba-cc03fb97df6c","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-30c1a977-8962-4e3e-aaff-f89fff0d79a8 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-94aed0e1-deb7-4fbc-b18f-4117475cc1da","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-635829a0-0735-441a-83fa-05c784d77ecb","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-98912a2a-75fa-4dfd-852a-29a9e0e0ff93","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-0dd6e6c2-8bb1-485b-b6b5-642cf2594e1f","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Learn More

Also known as a high-level data model, ER model shows the relationship among the entity sets. It helps developers design the logical design of the system from a data perspective.

[{"selector":"#anim-87849e9c-0a89-4baa-bc85-985110c52fa0 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-cbda0ecb-e289-477b-b67c-a0821a5f7966","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-8f4e588d-d159-4b08-9844-e45e42697341","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-b23246bb-9a16-415a-bb43-655e370b4e38","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-55696284-fcee-40db-babd-d3c766791a5d","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Get the facts now

The ER diagram is used to sketch out a database design. It represent logical structure of databases by defining entities, their attributes, and their relationships.

[{"selector":"#anim-64dc1ab5-6132-4ffb-9f8d-58b42e643f44 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-a2509879-d684-4630-ad44-1832486544f8","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-1ca9a7d0-6dce-4b46-800c-3aa3aabc6084","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-f87fe18f-2457-432f-9724-1ac85cd2d7b8","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-81b6541b-8bfa-4f14-a0b2-f00ef6a2f256","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Learn More

Used as a blueprint for implementing data in specific software applications. Provide an overview of how your tables will be connected, what fields each table will have.

[{"selector":"#anim-b2291cf5-f521-44c6-a29c-2d7b7ed8685a","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-cf100ad5-f4d0-40cb-8965-dc934c0e7e57","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-5c865d12-72c2-4525-865d-59b739149e75 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-db2edd54-647c-4af1-8fc6-089f34fbe68c","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-458f909a-725e-411c-aaa3-bfeaf1dc3247","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Discover more reasons

1. Entity 2. Attribute 3. Relationship

[{"selector":"#anim-4ba01b58-eb16-42b0-8218-ff4ba280d350 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-89ab43eb-573f-4353-8745-9c2a462afbc9","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-3ffa808c-d1e4-4c17-a2c1-fcf8f3fdb130","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-b8db3e87-2444-4ace-8c43-c41aae5e1ac1","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-aaecb32e-f653-45f4-ad35-acc4aef87359","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Check them now

1. One to One It creates a relationship between two tables where one row of one table can only be related to one row of another table.

[{"selector":"#anim-9b77c311-6b02-47b3-997c-4914f467975b [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-89400b6b-0419-4e9c-aa3c-f9cd16dff57c","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-39c53dfd-b7c3-42b7-ba36-ae2eff42e9f7","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-80f0dadc-d9dc-4329-a2d3-a1f3b9452bce","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-ce88ccfc-e816-4a1a-92c9-9858908660cf","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Check out example

2. One to Many It creates a relationship between two tables where one row of one table can only be related to one or more rows of another table.

[{"selector":"#anim-bed700af-62f5-486f-8c04-b2f8a0989f6e [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-abf65875-1d2f-4a14-84b8-875540537e0c","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-15f8e5dc-5d50-447b-9c9a-545892231546","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Check other types

Check out how to create ER diagrams and their various features.

[{"selector":"#anim-80d164b0-ac93-4881-bc27-8a9a0a7aa1ef","keyframes":{"opacity":[0,1]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c9a87b0c-8a08-4202-9fb8-3077e4975859","keyframes":{"transform":["translate3d(0px, 159.23319%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Explore Now

ER Model in DBMS

A Quick Overview

ER Model

Entity-Relationship Model

Also known as a high-level data model, ER model shows the relationship among the entity sets. It helps developers design the logical design of the system from a data perspective.

Introduction to ER Model

The ER diagram is used to sketch out a database design. It represent logical structure of databases by defining entities, their attributes, and their relationships.

What is an ER Diagram?

Used as a blueprint for implementing data in specific software applications. Provide an overview of how your tables will be connected, what fields each table will have.

Why use ER Diagram?

1. Entity 2. Attribute 3. Relationship

Main components of ER Diagram

1. One to One It creates a relationship between two tables where one row of one table can only be related to one row of another table.

Types of Relationships

2. One to Many It creates a relationship between two tables where one row of one table can only be related to one or more rows of another table.

Check out how to create ER diagrams and their various features.