What is data model? Describe various data models. DBMS

Data Model: Data model is the structure of the database, which is a collection of conceptual tools for describing data, data relationships, data semantics and consistency constraints. 

The data models can be classified into the following four categories.

    What is data model? Describe various data models. DBMS
  1. Relational Model: The relational data model uses a collection of tables to represent both data and the relationships among those data. This is like a record-based type, where each table holds different types of data and has relation among them so that they can be retrieved in a way the user wants to. 
  2. The Entity-Relationship Model: The entity-relationship data model is based on a perception of the real world where we can have many objects, called entity, which are distinguishable from each other and relations among them. This model is widely used.
  3. Object Based Data Model: The object based data model can be seen extending the entity-relationship model with ideas of encapsulation or summarization, methods and object identity. 
  4. Semi-structured Data Model: In semi-structured data model individual data items of the same types may have different sets of attributes. This is quite opposite to the other models where particular type of data has the same set of attributes.

Author: Tanmay Chakrabarty

Tanmay Chakrabarty is a former CSE student, currently working as a Senior Software Engineer with 5+ years of experience in the field of Web Application development in PHP+MySQL platform with strong skills in Javascript, JQuery, JQuery UI and CSS. He tries to write notes every week but fails due to heavy loads of duty.

Recommended Recommends


Contact Us