Ask a question from expert

Ask now

Data Modelling and Sql Language - Assignment

18 Pages2256 Words44 Views
   

Added on  2021-02-21

Data Modelling and Sql Language - Assignment

   Added on 2021-02-21

BookmarkShareRelated Documents
DATA MODELLING & SQL LANGUAGE
Data Modelling and Sql Language - Assignment_1
Table of content
INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
Database management system.........................................................................................................1
Differentiate between the file and database management system...............................................1
Properties Network, Relational and Hierarchical data models....................................................2
Bottom up and Top-down approach of relational DBMS design................................................3
TASK 2: CONCEPTUAL MODELLING.......................................................................................4
Possible entities...........................................................................................................................4
Conceptual data model for the New Airline database.................................................................4
TASK 3............................................................................................................................................5
LOGICAL MODELLING...............................................................................................................5
Normalization Method.................................................................................................................5
Entity relationship diagram..........................................................................................................7
TASK 4: PHYSICAL MODELLING...........................................................................................13
SQL Commands and database tables.........................................................................................13
CONCLUSION..............................................................................................................................16
REFERENCES..............................................................................................................................17
Data Modelling and Sql Language - Assignment_2
INTRODUCTION
A DBMS is a process that can gather and collect the information to store, retrieve and
update in the database system. It is used MySQL tool and platform to interface with the
information about database for storage and retrieval. This report will discuss about the
differentiation between the file base system and database. Furthermore, it will identify the
characteristics of data models. This documentation will discuss about the top down and bottom
up approach in relational database to examine the entire processing of DBMS. It is understanding
the entity relational model for establishing the relation between different entities. It also contains
the conceptual modelling to identify the entities and create the conceptual model. Moreover, this
report will identify the structure query statement that can use for designing table and columns in
the system.
TASK 1
Database management system
Differentiate between the file and database management system.
Database can be defined as a set of structure of data which is used to collect information
in a specified manner so that it can easily be accessed, updated, modified and retrieved. It makes
evaluation of information easy (Egea and Dania, 2019). There are various kinds of database
managed systems that are used to store information and manage different databases. Database
systems makes is much easier for the end user to update, create, read, delete data in a specified
manner such that other information stored within the database is not hampered. As per the case
study Jet Airlines wants to create dynamic relational DBMS in order to maintain the requirement
of their growing business.
Fine management system can be defined as an application which is used to store, arrange
as well as access information or files from storage locations. Each file within this file
management system manages as well as defines their own data or information (Ghali and
AbuNaser, 2019). There are various kinds of limitations because I this each and every user need
to maintain and create their own files which are run through a specific program. Due to which it
becomes difficult for the user to maintain, update, create or evaluate the information.
1
Data Modelling and Sql Language - Assignment_3
Properties Network, Relational and Hierarchical data models
Relational:
It is the most common model that help for sorting data into different tables and establish
relationship with one or more tables. It is mainly containing different rows or columns. Every
column has a contain the unique attributes (Odarchenko, Hassan and Zaman, 2019). This model
is mainly accounts for different types of relationship between tables such as one to one, one to
many and many to many etc.
Characteristics:
Relational model is represented in the form of tables that contain specific values within
rows.
It also supports the inapplicable and missing information in proper manner.
It must be supports the logical and physical data dependence.
Relational data model is also supports the independence of distribution the overall
management system.
Hierarchical
Hierarchical Model can organize information in the form of tree structure so that each
record has a contain the single parents. It is sorting in particular order and also used as physical
order for sorting the DBMS.
Characteristics:
It is based on the structured data model and structured in the tree.
It provides the navigation path to access the information through tree like structure.
It is mainly used for the logical pointers.
Network
It is mainly builds on the hierarchical model that can build many to many relationships. It
is also used the mathematical concept to create an effective network system and also constructed
with set of related records.
Characteristics:
It can be supports the many to many relationships.
All the entities are shown in the form of connected network with each other.
It always maintains high performance.
Network model is powerful than the other models.
2
Data Modelling and Sql Language - Assignment_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Data Modeling & SQL Language: Assignment
|22
|2594
|138

ICT701 Introduction of Database Systems
|9
|1215
|36

Data Modelling & SQL Language: Assignment
|11
|1420
|93

Data Modelling and SQL Language : Report
|31
|4640
|88

Database Design and Implementation
|15
|3038
|164

Database Design and Implementation
|15
|3038
|167