Database Management System | Report

Running head: DATABASE MANAGEMENT SYSTEM
DATABASE MANAGEMENT SYSTEM
Name of the Student
Name of the University
Author Note

DATABASE MANAGEMENT SYSTEM1
Table of Contents
ERD.................................................................................................................................................2
Normalization..................................................................................................................................3
First Normal Form.......................................................................................................................3
Second Normal Form...................................................................................................................3
Third Normal Form......................................................................................................................4
Form.................................................................................................................................................6
Tables...............................................................................................................................................6
Queries.............................................................................................................................................9
Report............................................................................................................................................11
Bibliography..................................................................................................................................12

DATABASE MANAGEMENT SYSTEM2
ERD
Entity Relationship Diagram represents the real world objects as entities and relationship
between them. Every entity has some attributes related to the entity itself. The relationship used
in the diagram are either one to one, one to many, zero to many or many to many. The below
diagram represents the Entities of the Airline system. The ERD is normalized in the later section
of the Report up to Third normal form.

DATABASE MANAGEMENT SYSTEM3
Figure 1: Entity Relationship Diagram
Source: Created by author
Normalization
Normalization is the process of simplifying the Tables and relationship between them. It
starts from the first normal form to the second normal form.
First Normal Form
According to the first normal form of the normalization, the tables must have all atomic
values and there are no repeating values. All the attributes are related to their entities and
relationship has been established according to the scenario.
Second Normal Form
Second Normal form says that the relationship should be in the first normal form and all
the non-key attributes should be fully functionally dependent on the key attribute of the table. In
the current scenario, table airplanes, flights and reservation are not in second form as, the type
and capacity of the airplane does not depends on the airplane no. hence; it will require an extra
sets of attribute which will be a new entity. In flight table, the flight date does not depends on the
flight no and in reservation table ticket description and status does not depend on the booking id.
Similarly the breakups of the table have been made to normalize the relationship into second
normal form. Below an example of the dependency diagram for the second normalized from has
been shown: