Flight Reservation System (FRMS)

Flight Reservation System Using ODP.Net and C# windows forms, It's an Application on Database Management and Relations between Entities.

Description

The FRMS helps the Customers to Register/login in the system and search for the available flight then determine it then Book it with (Source place, Destination place, number of tickets).

The FRMS Entities Divided Into (Customer, Airport, Flight, Seats):

• Customer (Name, Email, Password, Phone Number, Address, Passport Number, Credit_Card Number)
• Airport (Airport Name, Airport City, Airport Number)
• Flight (Flight Number, Flight Date, Launch time, Des time, Source place, Destination place)
• Seat (Seat Number, Seat Status, Seat Price, Number of seats)

Prerequisites

1. Install Visual Studio
2. Install Crystal Reports with the same version of VS
3. Any Oracle Database.

Getting into the project

ERD

Schema

🔸 Database SQL Script
🔸 Database Stored Procedures

Screenshots

Home Page:

Sign In Page:

Sign UP Page:

Profile Page:

Search For Flights Page:

Booking Page:

Manage Booking (Update/Delete):

Other Screenshots

Crystal Reports

Airports Flights Schedualing:

Countries Flights Schedualing:

References/Resources

• .Net Guide

• Database Guide

• Oracle Database

• Crystal Reports