Airlin reservation database project

CLASS ASSIGNMENT PROPOSAL.
Airline resrevation Database management system
Description of the database system.
Airline reservation database management system will provide features for both costumers of the company and the company itself. Database system will meet almost all needs of an airline company. It will be possible for costumers to make reservations, buy ticket, see and manage old reservations etc. All of these will be held in the database. In Airline Company Database Management System, there are various entities required such as planes, cities, airports, flights, customers, reservation and system user.

Tables of different databases that make up the system.

1. Table name: AIRBUS

Fields
Data Type
Size
Airbusno
AutoNumber
(5)
First_cap
Number
(3)
Bus_cap
Number
(3)
Eco_cap
Number
(3)
First_wl_cap
Number
(3)
Bus_wl_cap
Number
(3)
Eco_wl_cap
Number
(3)

2. Table name: CUSTOMER

Fields
Data Type
Size
name
Text
(7)
Phone_no
Number
(12)
address
AutoNumber
(8)
ID_no
Number
(8)
Date of dep
Number
(8)

3. Table name: CANCELLATION

Fields
Data Type
Size
PNR
Number
(5)
Flight_no
AutoNumber
(7)
Flight_date
Date
(20)
Class
Text
(1)
Reserv_date
Date
(20)
Pass_name
AutoNumber
(20)
Pass_add
AutoNumber
(100)
Passport_no
Number
(8)
Cancel_date
Date
(20)
Total_fare
Number
(8,2)
Flight_type
Text
(1)
Pass_status
AutoNumber
(15)
Canc_amt
Number
(8,2)

4. Table name: RESERVATION

Fields
Data Type
Size
PNR
Number
(5)
Flight_no
AutoNumber
(7)
Flight_date
Date
(7)
Class
Text
(1)
Reserv_date
Date
(20)
Total_fare
Number
(8,2)

5.Table name: FLIGHT

Fields
Data Type
Size
Flight_no
AutoNumber
(7)
Flight_date
Date
(20)
First_bk_seats
Number
(3)
Bus_bk_seats
Number
(3)
Eco_bk_seats
Number
(3)

6.Table name: FLIGHT_SCH

Fields
Data Type
Size
Flight_no
AutoNumber
(7)
Airbusno
AutoNumber
(5)
Airbus_nm
AutoNumber