Friday, April 24, 2020

Explain Database model & it's types in DBMS with diagarm


                            Database models & it's definition 



 Database model: - Database model defines the logical design and structure of database and defines how data will be stored and updated in a database management. Data Models are fundamental entities to introduce abstraction in a DBMS.
1) Hierarchical Model: - This database model organizes data into a tree like structure with a single root to which all the other data is linked. The hierarchy starts from root data and expands like tree, adding child nodes to the parent nodes. In this model a child node will only have a single parent node. This model efficiently describes many real world relationship like index of a book, recipes. In hierarchical model, data is organized into tree like structure with one, one to many relationship between two different types of data.


 2)  Network 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 relationship established in this model. As the data is related, hence accessing the data is also easier and fast. This database model was used to map many to many data relationship.



 3) Entity relationship model (ER model): - In this model relationship are created by dividing objects of interest into entity and its characteristic into attributes. ER model are define to represent the relationship into pictorial form to make it easier for different situation to understand. This model is good to design a database which can be turn into tables in relational mode.


         I.        4) Relational model: - In this model, data is organized into two dimensional tables and relationship is maintain by storing a common filed. Basic structure of data in the relational model is tables. All the information related to a particular type is stored in rows of that table.




No comments:

Post a Comment