Database model describes the structure of a database. Data model is collection of conceptual tools for describing data, relationship etc. There are different type of database model which are as follows:
It is a modified version of the hierarchical database (extension of the Hierarchical database model). In this database model, each nodes are allowed to have more than one parent. Searching is faster than hierarchical database model. And it is more flexible than hierarchical database model. Its structure is more complicated and less user-friendly than hierarchical database model/structure. Before relational database model was introduced this database is mostly use database model. It accept ‘many-to-many’ relationship.
Advantages
Disadvantages
Relational Table
Fig Relational database model
Advantage
Disadvantages
- Hierarchical Database Model
Hierarchical database model is a database which records are
logically organized into a hierarchy of relationship. It organizes the data
into a tree-like structure (pattern). The records of hierarchy are called
nodes. In this model of database, each node is related to the others in a
parent-child relationship. This database model’s parent record may have one or
more child record and a child nodes will only have a single parent node. Its
searching is fast and easy, if parent is know. It is organised into ‘One-to-Many’
relationship.
Advantages
- It is the easiest model of database.
- Searching is fast and easy, if parent is known.
- It supports ‘One-to-Many’ relationship.
Disadvantages
- It is traditional database model (old model).
- It can not support ‘Many-to-Many’ relationship.
- When the parent node is deleted, all the child nodes are deleted automatically.
- Network Database Model
It is a modified version of the hierarchical database (extension of the Hierarchical database model). In this database model, each nodes are allowed to have more than one parent. Searching is faster than hierarchical database model. And it is more flexible than hierarchical database model. Its structure is more complicated and less user-friendly than hierarchical database model/structure. Before relational database model was introduced this database is mostly use database model. It accept ‘many-to-many’ relationship.
Advantages
- It is more flexible than hierarchical database model.
- It accepts ‘many-to-many’ relationship.
- It has lower redundancy than hierarchical database model.
- Searching is faster.
Disadvantages
- It is less user-friendly compared to hierarchical model.
- it is open to all so it is less secured.
- It is complex database model.
- Relational Database Model
The database model which is arranged in two-dimensional tables
is known as relational database model. It is very easy for a user to develop
and understand. The basic structure of data in the relational model is tables. In
this database model, tables are known as relations. All the information related
to particular subject is stored in rows of the table. Normalization of the
database is possible. It has very less data redundancy rate. It is more complex that other database models. No processing can be done without establishing the
data relationships.
Table 1 Table 2
Roll no.
|
First
name
|
Last
name
|
Id_st
|
Subject
|
Teacher
|
|
1
|
Peter
|
Buffet
|
111
|
Math
|
Mark
|
|
2
|
Harry
|
Parker
|
222
|
Science
|
Dre
|
|
3
|
Sanjay
|
Dhakal
|
333
|
English
|
Denial
|
Relational Table
Roll no.
|
Id_st
|
Marks
|
1
|
111
|
80
|
2
|
222
|
65
|
3
|
333
|
95
|
Fig Relational database model
Advantage
- It has very less data redundancy rate.
- Normalization of the database is possible.
- Rapid processing of database is possible.
Disadvantages
- It is more complex than other models
- It is very hard to understand so it is non-user-friendly.
- Its is expensive while setting and maintaining the database system.
0 Comments