Scribd
Upload
55 views2 pages

Tables

The document describes the structure of several database tables used to store information about airline flights and reservations. The tables include Airlines_Master, Category_Master, Class_Master, City_Master, Day_Master, Meal, Service, Status_Master, Airlines_Service, Airline_Meal, Flight, Flight_Days, Flight_Details, Passenger, and Reservation. Each table contains fields with data types like varchar, char, int, and datetime to store details like airline codes, flight routes, dates, passenger information, and booking statuses.

Uploaded by

satyanandaram
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as RTF, PDF, TXT or read online on Scribd
55 views2 pages

Tables

The document describes the structure of several database tables used to store information about airline flights and reservations. The tables include Airlines_Master, Category_Master, Class_Master, City_Master, Day_Master, Meal, Service, Status_Master, Airlines_Service, Airline_Meal, Flight, Flight_Days, Flight_Details, Passenger, and Reservation. Each table contains fields with data types like varchar, char, int, and datetime to store details like airline codes, flight routes, dates, passenger information, and booking statuses.

Uploaded by

satyanandaram
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as RTF, PDF, TXT or read online on Scribd
You are on page 1/ 2

Tables

Airlines_Master
Aircode : Char (2) : PK
Airline_Name : Varchar(15)

Category_Master
Category_Code : Char(2) : PK
Description : Varchar(15)

Class_Master
Class_code : Char(3) : PK
Class_name : varchar(15)

City_Master
City_Code : Varchar(5) : PK
City_Name : Varchar(15)
Country : Varchar (15)

Day_Master
Day_Code : Int (4) : PK
Day_Name : Varchar(12)

Meal
Meal_Code : Varchar(5) : PK
Meal_Name : Varchar

Service
Service_Code : Varchar(3) : PK
Service_Name : Varchar

Status_Master
Status_Code : Varchar : PK
Description : Varchar

Airlines_Service
Aircode : Char (2) : FK
Service_Code : Varchar (3) : FK

Airline_Meal
Aircode : Char (2) : FK
Meal_Code : Varchar (5) : FK

Flight
Aircraft_code: Varchar : Pk
Aircode : char : FK
Type : Varchar
Source : Varchar
Destination : Varchar
Category : Varchar
Dep_time : Varchar
Journey_Hrs : Int

Flight_Days
Aircraft_code : Varchar : FK
Day_Code: Int : FK
Flight_Details
Aircraft_Code : Varchar : FK
Class_Code: Char : FK
Fare : Numeric
Seats : Numeric

Passenger
PNR_No : Numeric(9) : PK
Ticket_No: Numeric (9)
Name: Varchar(15)
Age : int (4)
Sex:Char(10) : Male / Female
PPNO: Varchar(15)
Meal Pref: Varchar(20)

Reservation
PNR_No: Numeric(9) : FK
Aircraft_Code : Varchar(5) : FK
Journey_date : datetime(8)
Class_code : Char(3)
No_of_seats : int (8)
Address : Varchar (50)
Contact_No: Numeric (9) --> Should not be less than 9 and Should not accept any other character other
than Integer
Status: Char (2) : Yes / No

You might also like