MSV Airlines

Overview

The purpose of our website is to allow users to view information about available flights and buy the ticket. We targeted to make our website user-friendly by using React. For the server side, we used Node.js and Express.js. We also used PostgreSQL to store all information in our database.

EER Diagram

Main Functionality

There are seven main features that we implemented for our website.

Sign up for new customers and employees

All users must sign up for a free account to use our website. When a new customer or a new employee signs up successfully, their information will be transferred back to our database.

Log in for existing customers and employees

After users have their own accounts, they can use their username and password to log in to our website. If the user is a customer, the next page will automatically show options for the customer to search for their desired flights. If the user is an employee, the next page will automatically show a list of customers with an option to view their flight information.

Search for flights based on origin, destination, departure date, and return date (if round-trip is chosen)

Users will fill out the information about origin, destination, depart date, and return date (if round trip) to begin the search. In this functionality, we give the users two options round-trip and one-way.

View departure and return flights

When the user clicks the search button, the information in our flights table will be fetched and displayed for the user. From there, the user can pick the best one that is the most convenient for them.

Create a booking

After the customer books their flights, they will be navigated to a booking confirmation page. On this page, we will display the customer ID, first name, and last name, followed by the flight information.

View, modify, and delete bookings

We also implemented a function for customers to see their flight information when they click on "My Flight" in the navigation bar. From here, customers can decide to modify or delete flights as needed.

Employee access customer information and their bookings

After an employee logs in, a list of customers with their information will be displayed. If an employee wants to assist a specific customer, they can choose and click on "View User" and the page will be automatically navigated to that customer’s flights information.