What is ER Modeling? Learn with Example - Shikshaglobe

Content Creator: Vijay Kumar

What is ER Modeling?

Element Relationship Model (ER Modeling) is a graphical way to deal with data set plan. It is a significant level information model that characterizes information components and their relationship to a predefined programming framework. An ER model is utilized to address genuine articles.

An Entity is a thing or item in true that is discernable from the general climate. For instance, every representative of an association is a different element. Following are some of the significant attributes of substances.

A substance has a bunch of properties.

Element properties can have values.

We should consider our most memorable model once more. A representative of an association is an element. If "Peter" is a software engineer (a worker) at Microsoft, he can have credits (properties) like name, age, weight, level, and so on. Clearly, those really do hold values applicable to him.

Each characteristic can have Valued. By and large single characteristic have one worth. Be that as it may, it is workable for credits have different qualities moreover. For instance, Peter's age has a solitary worth. Be that as it may, his "telephone numbers" property can have various qualities.

Substances can have associations with one another. How about we think about the most straightforward model. Expect that each Microsoft Programmer is given a Computer. Obviously that Peter's Computer is additionally an element. Peter is utilizing that PC, and a similar PC is utilized by Peter. All in all, there is a shared connection between Peter and his PC.

Improved Entity Relationship (EER) Model

The improved Entity Relationship (EER) Model is a significant level information model which gives expansions to the unique Entity Relationship (ER) model. EER Models uphold more subtleties plan. EER Modeling arose as an answer for displaying exceptionally complex information bases.

EER utilizes UML documentation. UML is the abbreviation for Unified Modeling Language; it is a universally useful demonstrating language utilized while planning object-situated frameworks. Elements are addressed as class graphs. Connections are addressed as relationships between elements. The graph displayed underneath represents an ER chart utilizing the UML documentation.

Why use ER Model?

All presently you might think why utilize ER demonstrating when we can essentially make the data set and its articles without ER displaying? One of the difficulties confronted while planning a data set is the way that fashioners, designers, and end clients will generally see information and its use in an unexpected way. In the event that this present circumstance is left uncontrolled, we can wind up delivering a data set framework that doesn't meet the prerequisites of the clients.

Specialized apparatuses comprehended by all stakeholders(technical as well as non-specialized clients) are basic in delivering data set frameworks that meet the necessities of the clients. Emergency room models are instances of such instruments.

Trama center graphs likewise increment client efficiency as they can be effectively converted into social tables.

Contextual analysis: ER chart for "MyFlix" Video Library

How about we currently work with the MyFlix Video Library data set framework to assist with understanding the idea of ER charts. We will involve this data set for all hands-on in the rest of this instructional exercise

MyFlix is a business substance that rents out motion pictures to its individuals. MyFlix has been putting away its records physically. The administration currently needs to move to a DBMS

We should take a gander at the moves toward fostering EER outline for this information base-

Recognize the substances and decide the connections that exist among them.

Every element, characteristic, and relationship, ought to have suitable names that can be handily perceived by non-specialized individuals also.

Connections ought not to be associated straightforwardly with one another. Connections ought to interface elements.

Each property in a given element ought to have an exceptional name.

Elements in the "MyFlix" library

The elements to be remembered for our ER graph are;

Individuals - this element will hold part data.

Films - this element will hold data with respect to motion pictures

Classifications - this substance will hold data that places films into various classifications, for example, "Show", "Activity", "Epic" and so on.

Film Rentals - this substance will hold data about motion pictures leased to individuals.

Installments - this substance will hold data about the installments made by individuals.

Characterizing the Relationships Among Entities

Individuals and motion pictures

The accompanying turns out as expected in regards to the communications between the two substances.

A part can lease more than one film in a given period.

A film can be leased by more than one part in a given period.

From the above situation, we can see that the idea of the relationship is many-to-many. Social data sets don't uphold many-to-numerous connections. We want to present an intersection substance. This is the job that the MovieRentals element plays. It has a one-to-numerous relationship with the individual's table and another to-numerous relationship with the film's table.

Films and classifications of substances

The accompanying turns out as expected about films and classifications.

A film can have a place within one class however a classification can have more than one film.

We can conclude from this that the idea of the connection among classifications and motion pictures table is one-to-many.

Individuals and installments elements

The accompanying turns out as expected about individuals and installments

A part can have one record yet can make various installments.

We can conclude from this that the idea of the connection among individuals and installments substances is one-to-many.


The full type of ER is Entity and Relationships Diagrams. They assume a vital part in the data set planning process. They act as a nonspecialized instrument for specialized and non-specialized individuals.

Elements address genuine things; they can be reasonable as a deal request or actually like a client.

All elements should be given interesting names.

Trama center models likewise permit the information base creators to distinguish and characterize the relations that exist among elements.

Must Know!
Drools Tutorial: Architecture of Drools Rule Engine and Example
Functional Requirements vs Non Functional Requirements
Manual Testing Tutorial: What is, Concepts, Types & Tool
Microsoft Visio Tutorial: What is, How to Use with Examples
What is a Non-Functional Requirement? Types and Examples


what is er modelingwhat is er modelwhat is er model explain with examplewhat is er model in dbmswhat is er model in dbms in hindiwhat is er model in databasewhat is er model in dbms with examplewhat is er model in software engineeringwhat is er model and its componentswhat is er model explain in detailwhat is er model diagramwhat is er model in rdbmswhat is er model and er diagramwhat is er model in the dbmswhat is an entity relationship modelwhat is difference between er modeling and dimensional modelingwhat is er model definitionwhat is er-modelwhat is true about er modelingwhat is er model basic conceptswhat is the difference between er modeling and dimensional modelingwhat is the bert modelbert model codewhat is bert model used forwhat is er diagram in computerwhat is er model explain its conceptwhat is er model explain its componentswhat is er model databasewhat is er diagram definitionwhat is entity relationship data modelwhat is entity relationship database modelwhat is er diagram in databasewhat is extended er model in dbmswhat is er modeling in dbmswhat is er model explainwhat is entity relationship model explainwhat is er diagram explain with examplewhat is er diagram explainwhat is er diagram exampleswhat is er model with examplewhat is enhanced er modelwhat is er diagram used forer modelling is primarily used forf and f actorswhat is er modeling groupwhat is er modeling githubwhat is er modeling good forwhat is er modeling guidancewhat is er modeling google sheetswhat is er modeling grammarwhat is er modeling gerdwhat is er model in hindiwhat is er diagram and how to drawwhat is er model in sqlwhat is entity relationship model in databasewhat is er diagram javatpointwhat is er modeling kitwhat is er modeling keywhat is er modeling knowledgewhat is er modeling k8swhat is er modeling kineticswhat is er model kya haiwhat is er model key constraintswhat is er model keyneswhat is er model kosmowhat is er model kali diperkenalkan pada tahunwhat is er modeling likewhat is er modeling languagewhat is er modeling layerwhat is er modeling lifewhat is er modeling los angeleswhat is erd modeling logicalwhat is erd modeling logisticswhat is erd modeling look likewhat is er diagram in mysqlwhat is an ma modelm/m/1 model is known asis m models legitwhat is er diagram in oraclewhat is the purpose of er modelingwhat is o s i modelwhat is er diagram pdfwhat is er diagram in projectwhat is er modeling querywhat is er modeling questionswhat is er modeling queuewhat is er modeling quantities answer keywhat is er modeling quantitieswhat is er modeling quantities lesson 1-2 answerswhat is er model questions and answerswhat is er model quizwhat is er model questions in gatewhat is er model question paperwhat is er diagram representationer model in dbmswhat is entity-relationship (er) modelwhat is er model to relational modelwhat does er diagram representwhat is r modellingwhat is er diagram symbolswhat is er diagram in sql serverwhat is er model discuss by telling an examplewhat is the entity relationship modelwhat is the entity relationship model in database designwhat is t modelwhat is er modeling videowhat is er modeling versionwhat is er modeling viewwhat is er modeling vs machine learningwhat is er modeling vs modelingwhat is er modeling vs dimensional modelingwhat is erd model visiowhat is erd model vs erwhat is entity relationship model with examplewhat is er diagram with examplewhat is er modeling xmlwhat is er modeling xml filewhat is er model xwhat is er model x et godt kjøpwhat is er model xrwhat is er modeling youtubewhat is er modeling yamlwhat is er modeling your a nerdwhat is er modeling zonewhat is er modeling zscalerwhat is er model zhangwhat is er model zadaciwhat is er model zzp-erwhat is er modeling 101what is er model 1 to manywhat is er model 1 to nwhat is er modeling 2023-24