Airlines Management System

Flight Management System using MERN Stack. It consists of an Admin Panel having specified permissions to access the database along with a Customer Panel having specified CRUD operations control and book as many tickets as they want. This was a fifth semester project for Database Systems course of FAST NUCES.

Table of Contents

• Installation
  • Client
  • Server

Installation

Client

1. Navigate to the client directory.

cd client

2. Install the required react dependencies through.

npm install

3. Run the frontend server.

npm start

Server

1. Navigate to the server directory.

cd server

2. Install the required react dependencies through.

npm install

3. All the commands to create all the functionalites for the sql database are in Database.sql file. You have to run them one by one to create all the required tables, triggers and other procedures.

4. Change this code snippet in the index.js file accordingly. The comments represent the values I have set for my local machine.

   const db= mysql.createPool({
    host:"localhost",
    user:"your_sql_db_name",
    password:"your_sql_db_password",  
    database:"your_database_name"   //airport_management
});

5. Run the backend server.

nodemon index.js