Database Design and Development for Flight Booking System

Database Design and
Development

Table of Contents
1 Project Objective.................................................................................................................3
2 Entity Relationship Diagram..............................................................................................3
2.1 Entities.........................................................................................................................3
2.2 Attributes.....................................................................................................................4
2.3 Associative Entities.....................................................................................................7
2.4 Weak Entities...............................................................................................................7
3 Assumptions and Business rules.........................................................................................8
4 Logical Design..................................................................................................................10
5 3NF Relations...................................................................................................................12
References...........................................................................................................................................14

1. Project Objective
The main objective of this project is to design and implement a database system for
managing the business of flight booking. It is assumed that the IT service company is hiring
you to design and implement the database system for managing the business of flight
booking. So, it is required to design the relational database and it can be served as an
important software component for a travel Meta search engine platform. The relational
database requires the relevant business data, which are recorded and processed efficiently.
The proposed database designs requires tracking and recording all the information of flights
such as, airlines, flight number, flight name, customers details, ticket booking, airports, and
so on. The flight information consists of the following attributes such as, flight number,
departure and arrival airports, departure and arrival time, price, type of aircraft and airline
code. The proposed database system also needs to record the customer information such as,
customer full name, address and phone number. The customers are divided into two types
like, individual and business customers. Any individual customer will have a personal travel
insurance cover, which is recorded. The business customers’ details are also recorded like,
organization name, special deal and Australian business number. The proposed data base
system is allowing the customer to book one or more flights. The Flight booking details are
recorded in the proposed database system such as, unique reservation code, booking data, and
total price. The booked flight details are recorded like, booked flight number, departure and
arrival time, airport, class, seat number and travel date. Finally, the customer makes the
payment and this information is also recorded in the proposed database system.
2. Entity Relationship Diagram
2.1 Entities
The flight booking database system has the following entities such as,
 Customer
 Booking
 Customer Type
 Payment
 Flight
 Individual customers
 Business Customers
 Invoice

2.2 Attributes
The Customer table contains the following attributes such as, Customer ID, Full
name, address and contact phone number. Here, the customer ID is, the Primary key (Pathak,
2011).
The Flight table contains the following attributes such as, flight number, airline code,
departure time, arrival time, departure airports, arrival airports, price and types of aircraft.