Skip to content

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

License

Notifications You must be signed in to change notification settings

kareem983/Flight_Reservation_System

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

37 Commits
 
 
 
 
 
 

Repository files navigation

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

ERD Diagram

Schema

Schema Diagram

🔸 Database SQL Script
🔸 Database Stored Procedures

Screenshots

Home Page:
Home

Sign In Page:
Sign In

Sign UP Page:
Sign UP

Profile Page:
Profile

Search For Flights Page:
Search For Flight

Show Flights

Booking Page:
Booking

Booking Process

Manage Booking (Update/Delete):
Manage Reservation

Other Screenshots

Crystal Reports

Airports Flights Schedualing:
Flights Reporting

Countries Flights Schedualing:
Towns Reporting

References/Resources

About

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

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages