Database Design and System Analysis for Rwenzori Airline Reservation

This case study focuses on the system analysis and design of an online reservation system for Rwenzori Airline. The assignment begins with a justification for the system's development, highlighting the inefficiencies of the existing manual processes and the benefits of an automated system, such as reduced queues, decreased paperwork, and cost savings. The project scope includes requirements definition and the interaction between management and customers. The Waterfall SDLC model is selected, and the project cost is estimated. The design incorporates UML diagrams, including a Use Case diagram illustrating the interactions between passengers, the bank, and the admin; a Data Flow Diagram showing the reservation process; a Context Diagram providing an overview of the system; and an Entity Relationship Diagram detailing the data model. Screen interfaces, including the main menu, login page, and flight information report, are also presented. Finally, a Gantt chart is provided to illustrate the project timeline. The conclusion emphasizes the importance of thorough analysis and design in ensuring a functional and efficient system.

Student Name
Unit
System Analysis and Design
Database Designs
Rwenzori Airline Online Reservation System
Institution Affiliation

Introduction
System analysis and design has been considered as one of the major topics that one needs
to understand keenly when designing the conceptual design of a database. System analysis and
design entails the functionalities and non-functionalities system requirements and how the
system is interacting with the end-users. In any given system, the first step is to make sure that
analysis is done properly and that the design meets all the requirements as explained in the
analysis stage (Balanis, 2016). After the design one can easily implement the system by coding
which will, in turn, lead to giving the outcome. In this scenario, the Rwenzori is an airline
company that has been operating manually for air reservations and thus they saw a need to speed
their processes.
In this case, the company will be able to receive bookings from different customers all
over the country without having them coming to the base (Azar and Vaidyanathan, 2015). In this
case, they will save on time and much more on the effort of customers trying to get services as
the airline reservation system will ensure that all of them are served in all situations at the same
time without any queues. Ideally, for one to come up with a good system design, one must
understand all the stages of Software development. The major idea in this task is applying the
UML diagrams when designing the system.
Need For System Development
Ideally, as it is in many manual systems, there exist a lot of queues at the Airline where
all the time the customers find themselves queuing up for big lines trying to get for services
which in most cases they end up being not served within their time limit. Another concept is that
Rwenzori Company has been doing a lot of paperwork which in most cases leads to the creation
of a lot of files which sometimes can be tiresome especially when trying to retrieve a given file.
A lot of resources are wasted by the company by employing many staff whose work could have
been simplified by the use of an automated Airline Reservations system.
Benefits of Implementing Airline Online Reservation System
The system will help in reducing queues at the base as many will be opting to use
applications or the system when booking for flights and thus reducing congestion of people
(Wixom, 2015). Another benefit is that the company will reduce a lot of paper works thus
ensuring that all its services are all automated thus reducing most errors caused by humans such

as allocating one reservation to more than one person. The company will also be able to save on
cost and thus making it easy for them to manage its operations easily without major problems
(Gupta, 2017). Ideally, since all the entities are uniquely identified with distinct and specified
primary keys, the searching and sorting of records when booking or searching for flight
schedules, the system is so fast and reliable (Krishnan, 2017).
Scope of the Project
In this scope, the case study is entitled to take consideration such as the requirements
definitions. In the real world, the project requirements includes the implementation of a system
that will assist one in searching for the available flights and book for tickets. As it is in the case
study, the idea was to know how the management and the customers interacts with the Airline
Online Reservation System.
Schedule Analysis
The system seems to be much involving and thus the best Software development life
cycle is Waterfall. In this case, the system starts by being planned and ends up with maintenance
as clearly shown below. The system when created using this development approach will try to
cover all loopholes and much more involve all the stakeholders while planning and
implementing and thus helping in meeting the needs of the customers (Pedrycz, 2016).
Figure 1 Waterfall SDLC Model

Project Cost
Stages (Phases) Expected Cost (Dollars)
Planning $ 1000
Requirement Analysis $ 1500
System Design $3200
Implementation $10,000
Testing $2000
Deployment $1000
Maintenance $3000
TOTAL $21,700
Table 1project cost
Modelling Diagrams.
Use Case
Figure 2 Use Case Diagram

Ideally as shown in the above diagram, the passenger can login into the system and after
he has been given the logins he or she will be able to check on the available flights, book a ticket
and choose a seat after the payment has been validated by the system. In this use case diagram
there exists three major actors who perform different actions. The banks operations are for
validating the details of the cards. Admin can cancel the ticket and also at the same time update
on the flight schedules.
Data Flow Diagram.
Figure 3 DFD diagram
In the above data flow diagram, the reservation process has been expressed in all ways
explain how data flow from the moment the customer registers in the system of online
reservation system. The first step is the customer checking on the availability of the flights which
in turns will direct him to the prices and if that is friendly or is as per the expectations, then the
customer will book for reservations or seats after the payment has been validated.

Context Diagram
Figure 4 Context Diagram
As it is shown in the diagram above, the content in the context diagram is just as that of
the data flow diagram, the customer will have to check on the prices and availabilities of flights
and time so that he or she can be able to choose the best flight, on a given schedule, good ticket
on a given journey via the management using the Airline Reservation System.

Entity Relationship Diagram
Figure 5 ERD diagram
As seen in the diagram above, the customer have some major and significant attributes
that help in defining and identifying who is a customer. The customer is uniquely identified by
the Customer ID. The customer usually books a ticket which is uniquely identified by Ticket IT
which have to be belongs on a given schedule uniquely identified by Journey ID. The schedule
belongs to a given flight.

Data Conceptual Design of ERD
Figure 6 ERD DB conceptual Design
The conceptual diagram of the ERD is having five entities namely the Flight, Customer,
Ticket, Schedule and Journey. Each entity has got its own attributes as it is clearly shown where
each has a unique identifier which is the primary key.
Screen Interfaces

Figure 7 Main Menu
This is the main screen menu that shows the user the first page in the interface. In this
case or page, the user is introduced to the website and one can see the main links that the
websites deal with. This webpage discusses the main information that Rwenzori deals with. It
clearly shows the home page, about us, flight schedule and contact us.
Figure 8 Login Page
This is a page that usually allows one to login in to the system. One can register in as a
new user. One is required to use a username and insert a password to be able to access the
information in the system. Once the two matches with what has been installed in the system, then
one will be directly taken to the homepage where one can navigate from one page to the other.
Figure 9 Flight Information Report

This is a schedule report that clearly shows different flights and their schedules. In this
case, the diagram clearly shows that there are a number of flights which have got different
timelines or schedules. The report also clearly states the time the flight depart and the expected
time of arrival.
Gantt chart
Figure 10 Gantt Charts
Conclusion
Ideally as it have been seen in the report above, it is very much clear that all the
procedures and guidelines required during the analysis and system plan of the databases
requiring them to be highly focused in all ways.. For this situation, such mistakes and blames
that happens in the actualized framework can be profoundly checked in all viewpoints and along
these lines making this framework simple to address bugs. In any usage of a framework, the
examination and configuration stage decides the deliverable or the final result of the framework
in manners. Thusly, the framework can have the option to meet the necessities of the clients

References
Azar, A.T. and Vaidyanathan, S. eds., 2015. Chaos modeling and control systems design (Vol.
581). Germany: Springer.
Balanis, C.A., 2016. Antenna theory: analysis and design. John wiley & sons.
Dennis, A., Wixom, B.H. and Tegarden, D., 2015. Systems analysis and design: An object-
oriented approach with UML. John wiley & sons.
Dennis, A., Wixom, B.H. and Roth, R.M., 2018. Systems analysis and design. John wiley &
sons.
Gupta, A.K., 2017. Response spectrum method in seismic analysis and design of structures.
Routledge.
Krishnan, R., 2017. Switched reluctance motor drives: modeling, simulation, analysis, design,
and applications. CRC press.
Pedrycz, W., 2016. Granular computing: analysis and design of intelligent systems. CRC press.