Airline Reservation System for Aerozen Inc.

This presentation discusses the development of an advanced airline reservation system for Aerozen Inc. The system will allow customers to book and reserve flights, register themselves, and check for available airlines. The administrator will be able to assign facilities to different airlines, modify the number of available seats, and mark prices for airlines. The system will help Aerozen Inc. record customer activities on the web and mobile into one single profile.

AIRLINE
RESERVATION
SYSTEM
PRESENTED BY: <>

ABOUT BUSINESS:
• Aerozen Inc., is in the business of providing IT support .
• 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.

CURRENT ISSUES
• Their new client wishes to have an advanced airline reservation system
built-in that would not only allow them to book airline tickets.
• 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.

FEATURE OF PROPOSED DATABASE
• 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.

ER DIAGRAM

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.

ANY QUESTIONS??