Database Project: Airline Reservation System Design & Implementation

This project outlines the database design for an airline reservation system, addressing the needs of Aerozen Inc., an IT support company providing services to major tour operators. The system aims to create a centralized database to record customer activities from web and mobile platforms, enabling better understanding of customer behavior and providing advanced airline ticket booking capabilities. Key features include customer registration, airline reservation, facility allocation, and dynamic flight pricing. The project includes an ER diagram illustrating the relationships between entities such as customers, airlines, facilities, and reservations, along with considerations for database optimization and future improvements. The accompanying documentation covers business requirements, database design, database scripts, and a project timeline, providing a comprehensive overview of the system's development and implementation. Desklib provides similar solved assignments and resources for students.

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??