Data Modelling SQL Language Tasks 2022

Running head: DATA MODELLING & SQL LANGUAGE
Data Modelling & SQL Language
Name of the Student
Name of the University
Authors note

DATA MODELLING & SQL LANGUAGE
1
Task 1
Comparison of the File based system and database system for storing data
Advantages of File based system
Compactness of file system: In file systems it is possible to store data in compact
format. In addition to that, File System is easy-to-use in order to store general files that
require lesser amount of security.
Minimal investment and Easy to use: The usage of File based system requires
minimal investment to setup. As there is no investment in developing the software as file
system allows the users to transfer files from one computer to another without the
requirement of any specialist.
Disadvantages of File based system
Accessibility issue: In case of File System, data is stored in the form of different
isolated files on the computers that had their own properties as well as physical location on
hard drive. The user have to manually find and goes to the location of the stored file to get
and access the data which is time consuming.
Lack of consistency and integrity: Due to the isolated storage and integrity check of
the stored data, redundancy is more in the file system and this cannot be controlled easily. In
addition to that data consistency is also not met in the file based system leading to the loss of
resources.
Advantages of the Database system

DATA MODELLING & SQL LANGUAGE
2
Security of data: Database management system can ensure the high security of the
data through the use of the constraints in the database.
Centralization: On the contrast of the File based system the centralisation of the data
can be achieved in Database Management System which can help in availability of data.
Well defined and structured data: The Database Management System are capable
of storing data in a structured way with the use of the well-defined constraints on tables and
interrelation among them.
Disadvantages of Database system
Higher Cost: Required Cost in order to set up a DBMS according to the required
functions which incurs recurring annual maintenance cost to maintain the developed system.
Failure and loss data: Different kind failures such as the corrupted database due to
power failure/crashed system may lead to loss of huge amount of important data.
Characteristics of the of Hierarchical, network and relational database models
Characteristics of Hierarchical model
In the hierarchical model, data is stored in tree like structures where the parent kid
relationship is kept up. As it were it very well may be expressed that required information is
spared in top down or bottom up methodology. The data kept in the database is spoken to as
parent-kid relationship. In this database framework parent can have various kids, while the
child data node can have just one parent.
Application of Hierarchical model
The Hierarchical database model is utilized in the scenarios where very high
performance and high availability of the database is required for the front end applications.
As an example telecommunication and banking sectors/industries use this database model.