Data model: It is known as the design of a database management system, which can be used for the creation of a different kind of data model.
Types:
1)E-R model (entity-relationship model).
2)Relational model (Table)
3)Hirercial model.
Relational model: In the relational model, the data is represented in the form of tables. the tables are known as a relation in this model.
E-R Model:
To convert the E-R Model into the Relational model, the following changes have to be followed
i) Name of entity = Name of the table.
ii)Name of attribute = Name of the column.
iii)The Primary key or the key attribute remains the same.
Relational Model:
Ex:
Employee
Hierarchical Model: the tree-like structure is known as a hierarchical model. it will have a single root and many children.which is following one - many relationships.
<--prev
You can write to me at codingallrounders@gmail.com
please post your doubts in the comment box.
3)Hirercial model.
Relational model: In the relational model, the data is represented in the form of tables. the tables are known as a relation in this model.
E-R Model:
To convert the E-R Model into the Relational model, the following changes have to be followed
i) Name of entity = Name of the table.
ii)Name of attribute = Name of the column.
iii)The Primary key or the key attribute remains the same.
Relational Model:
Ex:
Employee
Hierarchical Model: the tree-like structure is known as a hierarchical model. it will have a single root and many children.which is following one - many relationships.
<--prev
I hope this article is useful to you, plz follow the next volume for more information.
You can write to me at codingallrounders@gmail.com
please post your doubts in the comment box.
Subscribe by Email
Follow Updates Articles from This Blog via Email
No Comments