Comparison between E-R Model and Object Oriented Model

The detailed comparison on the E- R model and Object Oriented Model is given as follows −

E-R Model

ER model is used to represent real life scenarios as entities. The properties of these entities are their attributes in the ER diagram and their connections are shown in the form of relationships. 

An ER model is generally considered as a top down approach in data designing.

An example of ER model is −

Advantages of E - R model

• The data requirements are easily understandable using an E - R model as it utilises clear diagrams.
• The E-R model can be easily converted into a relational database.
• The E-R diagram is very easy to understand as it has clearly defined entities and the relations between them.

Disadvantages of E-R model

• There is no data manipulation language available for an E- R model as it is a largely abstract concept.
• There are no standard notations for an E - R model. It depends on each individual designer how they design it.

Object Oriented Model

Object oriented data model is based on using real life scenarios. In this model, the scenarios are represented as objects. The objects with similar functionalities are grouped together and linked to different other objects.

An Example of the Object Oriented data model is −  

Advantages of Object Oriented Model

• Due to inheritance, the data types can be reused in different objects. This reduces the cost of maintaining the same data in multiple locations.
• The object oriented model is quite flexible in most cases.
• It is easier to extend the design in Object Oriented Model.

Disadvantages of Object Oriented Model

• It is not practically implemented in database systems as it is mostly a theoretical approach.
• This model can be quite complicated to create and understand.

Alex Onsman

Published on 24-Jul-2018 17:55:00

• Related Questions & Answers
• Difference Between E-R Model and Relational Model in DBMS
• Object-oriented Data Model
• Converting E-R model into relational model
• Examples of E-R model
• Object-oriented Life Cycle Model in Software Engineering
• Explain the object oriented data model in DBMS?
• Difference between Waterfall Model and RAD Model
• Difference between V-Model and WaterFall Model
• Difference between Incremental Model and WaterFall Model
• Difference between Spiral Model and Waterfall Model
• Difference Between Waterfall Model and Spiral Model
• How to extract the model equation from model object in R?
• Difference between Bottom-Up Model and Top-Down Model
• Object-relational Data Model
• Differences between Procedural and Object Oriented Programming.