Data Model | Types of Database Models in Database Management System(dbms) with example
#DataModel #DatabaseModel #Typesofmodels #Dbms #Relationaldatamodel #Networkdatamodel #Entity-Relationshipdatamodel #HierarchicaldataModel #Object-OrienteddataModel Types of Data Model:- 1) Relational Data Model 2) Hierarchical Data Model 3) Network Data Model 4) Entity-Relationship Data Model 5) Object-Oriented Data Model Topic cover in this video:- DATA MODEL:- Data model is a collection of concepts that can be used to describe structure of the database, provides the necessary means to achieve abstraction. Structure of a database means specialized format for organizing and storing data. Data models define how data is connected to each other and how they are processed and stored inside the system. A data model is a logic organization of the real world objects (entities), constraints on them, and the relationships among objects. Relational Data Model:- This type of model designs the data in the form of rows and columns within a table. This model represents data and relationships among data by a collection of tables known as relations. This model was initially described by Edgar F. Codd, in 1969. The relational data model is the widely used model which is primarily used by commercial data processing applications. It is easy to use and very much flexible compare to other Data model. Data independence is archive more easily with normalization. Network Data Model:- This is an extension of the Hierarchical model. In this model data is organized more like a graph, and are allowed to have more than one parent node. In this database model data is more related as more relationships are established in this database model. Data is more related, hence accessing the data is also easier and fast. This database model was used to many-to-many data relationships. Entity-Relationship Data Model:- An ER model is the logical representation of data as objects and relationships among them. These objects are known as entities, and relationship is an association among these entities. E-R Models are defined to represent the relationships into pictorial form to make it easier for different stakeholders to understand. This model is good to design a database, which can then be turned into tables in relational model. ER Model is based on:- 1) Entities and their attributes. 2) Relationships among entities. Object-Oriented Data Model:- Object oriented data model is based upon real world situations. These situations are represented as objects, with different attributes. All these object have multiple relationships between them. Elements of Object oriented data model Objects Attributes and Method Class Inheritance