A Travel Reservations Service application built as a part of Course Project for CS 4400: Introduction to Database Systems (Fall 2021 Semester).
The purpose of this project was to analyze, specify, design, implement, and document an online system based on a provided scenario description.
Design and develop a system to handle travel reservations. This system supports a "third party" travel reservations agency. Customers will make flights reservations and hotel/AirBnB bookings for their trips. After confirming the bookings, the agency will be paid electronically by the customer.
The types of users in the system include:
- Admin
- Client
- Customer
- Owner
The system was implemented using a relational DBMS that supports standard SQL queries. A Fully Functional Application integrated with Database System and User Interface specification was developed by the team.
Key User interface features include displaying different data in a dynamic tabular format with the option to search, sort and filter based on column values.
- React JS
- Styling - MUI
- Python
- Flask
- Flask-MySQLdb
- Flask-CORS
- simplejson
- datetime
- MySQL
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
 |
 |
 |
|
 |
 |
 |
 |
-
Clone this repository or download zip.
-
Install Node.js if you haven't already.
-
Replace the MySQL User and Password credentials in
/backend/app.pywith your local MySQL credentials. -
Run the SQL queries for Database creation, Views, and Stored Procedures on the MySQL server.
-
Open this repository on terminal. Navigate to backend folder by typing
cd backend. -
Type (if mentioned above python modules are not installed)
pip install Flask, flask-mysqldb, simplejson pip install -U flask-cors -
To run the backend,
python app.py -
Navigate to react folder in terminal by typing
cd .. cd react -
Install node_modules
npm install -
Begin the frontend web application by typing
npm start -
All set.
| Dhruv Karve | Geetha Priyanka | Nilavrah Sensarma | Kirti Chhatlani |
|---|