Efficient Database Design for Aerozen Inc.

Business scenario #1:
 Aerozen Inc., is in the business of providing IT support and services to some of the major
travel portals around the world. Their newest portal is a novel one and it requires
maintaining an active database for it’s customers. They need to develop a database that is
both efficient, fast and highly optimized so that it can support their client’s businesses.
 Aerozen Inc., is the name of our client. However, they in turn provide services to some of
the major tour operators around the world.
 They are into IT services and support and provide ITes to major travel operators around
the world.
 The head of IT outsourcing is handling the project.
 Their expectation is to deliver a working database design that would suit their
requirements in the given timeframe.
Business scenario #2:
 They are not facing any problem as such. Their new client wishes to have an advanced
airline reservation system built-in that would not only allow them to book airline tickets
but also want to record a trail of activities that their customer perform across their system
and then process that data and convert into actionable insights for them as well as provide
enhanced services for their customers. As a result, their newer system is a novel one and
would want a highly efficient database engine for it.
 They need the database so as to record their customer’s activities on the web and mobile
into one single profile.
 The database would help prove their business beneficial as it would help them make
sense of what their customers are doing on the web and record all the necessary activities
corresponding to their visit on the web.
Business Section # 3
The development of a database which can be accessed from any location and all data gets
stored at centralized position will make it easier for the customers to reserve flights without any
conflicts with one another.

Database Design # 1
Following features will be implemented while developing proposed system:
 Airline reservation – A customer will be able to book / reserve airline for the
travel by providing start and end dates.
 Customer registration – A customer will be able register oneself on the system to
reserve an airline.
 Facility allocation – The administrator should be able to assign facility to
different airlines.
 Marking prices of flights – The system should be able to mark prices for airlines
daily and also for a specific date.
Database Design # 2
Following are the assumptions:
 A customer is able to access the system and also register oneself.
 A customer can reserve an airline
 A customer is able to check for available airlines.
 An admin is able to modify the number of available seats.
 An admin is able to access the system to mark prices.

First ER diagram

Final ER diagram
Data dictionary
Table Description
T_AIRLINE This table contains all the information related to an airline.
Attribute Description Primary Key / Foreign
Key
airlineID Unique identifier given
to every airline.
Primary key
airlineName Full name given to an
airline
-