Database System for Jet Airlines

Running head: DATABASE SYSTEM FOR JET AIRLINES
Database System for Jet Airlines
Name of the Student
Name of the University
Author’s note:

DATABASE SYSTEM FOR JET AIRLINES1
Table of Contents
Task 1: Understanding of Database.................................................................................................2
1.1Database System VS File Based System:...............................................................................2
1.1.1 Database System:............................................................................................................2
1.1.2 File Based System:.........................................................................................................2
1.2 Hierarchical, Network and Relational Models:.....................................................................3
1.3 Top-down and Bottom-up Approaches:................................................................................3
Task 2: Conceptual Modelling.........................................................................................................4
Task 3: Logical Modelling...............................................................................................................6
Task 4: Physical Modelling...........................................................................................................13
Create Database:........................................................................................................................13
Create Table:..............................................................................................................................13
Bibliography:.................................................................................................................................19

DATABASE SYSTEM FOR JET AIRLINES2
Task 1: Understanding of Database
1.1Database System VS File Based System:
1.1.1 Database System:
The database system is considered as the set of database management system and
databases. The database system is for storing, fetching, updating and deleting data. Database
systems are consisted of database software that allows the user to perform all the intended tasks.
Database system handles both the operations and the data.
Advantages: The database system is effective enough to control the data redundancy
through its entities. There is minimum inconsistency in the database systems. If any change is
made in the database, all the interrelated data will be changed. The quality of service is also
better in the database systems.
Disadvantages: The complexity of the database is a huge disadvantage. The execution of
functions are complex than file based systems. The cost of the software and hardware makes it
difficult to implement.
Limitations: Without having prior knowledge of database systems, the user cannot store
or retrieve data from a database system.
1.1.2 File Based System:
The may be thought as a collection of computer programs which is capable of carrying
out the programming services regarding the intentions of end user for accessing information.
Each program has its own file which is maintained by that program itself.
Advantages: The traditional file based systems are easy to access. The files remains in
the central location physically, therefore establishing the connection is very easy. The file
systems are very easy to understand.
Disadvantages: The file systems are outdated and most modern framework and
technologies do not support it. The file systems are very prone to cyber-attacks. As there is no
proper security checks in the file based system other than server, the cyber-attacks can be done
very easily.

DATABASE SYSTEM FOR JET AIRLINES3
Limitations: Current frameworks does not support the file based systems.
1.2 Hierarchical, Network and Relational Models:
Hierarchical Model: In terms of the hierarchical data model, a structure similar to the
tree is implemented. The parent’s node has many children and these children can act like nodes.
Only the one-to-many relations are available within hierarchical data model.
Network Model: Network data model is developed using objects and relationships among
the objects. The network data model is a very scalable approach toward database
implementation. The schema in the network data model is represented through a data
visualization where the acrs are relationship and objects are nodes.
Relational Model: The set of relations within a database is presented through the
relational model. The relations are the tables that holds the raw data. Each relation is connected
to other relation or relations through relationships. Relations has constraint like primary key,
foreign key, default, check and many more. Most modern day medium sized database are
relations. These databases focuses on the interrelationship among the relations.
1.3 Top-down and Bottom-up Approaches:
Top-Down: Top-Down is popular for generating new databases. The database
development starts at logical level where the logical database is created. The information about
the data is collected and structured. All the information collected at the logical and conceptual
level is applied to the physical database implementation level.
Advantages of Top-Down
i. High-level view for all items
ii. Data change can be monitored efficiently
Drawbacks of Top- Down:
i. Takes a lot of time to create the database
ii. Each process should be done only in sequential manner