Page 78 - CITS - Computer Software Application -TT
P. 78
COMPUTER SOFTWARE APPLICATION - CITS
First_name last_name email phone
Designing Flat model
2 Hierarchical Model
The Hierarchical model design features a configuration resembling a tree. Within this tree structure, there
exists a root data node and subsequent child nodes. A one-to-many relationship is established between each
parent node and its child node. These types of database schemas find representation in formats like XML or
JSON files, which are capable of encompassing entities along with their respective sub-entities.
Hierarchical schema models excel in housing nested data, effectively representing instances like Hominoid
classification.
Designing Hierarchical Model
3 Network Model
The network model and the hierarchical model bear striking resemblances, but a significant disparity lies in
their handling of data relationships. The network model permits the existence of many-to-many relationships,
in contrast to the hierarchical models, which solely accommodate one-to-many relationships.
4 Relational Model
Relational models serve as the foundation for relational databases, where data is stored in the form of tables
or relations. Within this context, relational operators are employed to manipulate and compute various values
from the data.
65
CITS : IT&ITES - Computer software application - Lesson 18 - 36