Airline Database Schema Overview

Uploaded by

mnzxbvcv2008

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

9 views1 page

Airline Database Schema Overview

Uploaded by

mnzxbvcv2008

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

You are on page 1/ 1

Passengers Ticket

PK Ps_ID number(10) Booking PK Tc_ID number(10)

Fname varchar2(20) Ps_name varchar2(20)
PK Bk_ID number(10)
Lname varchar2(20) Coust number(10)
FK Ps_ID number(10)
Ps_Phone_num number(10) DestinationAirport varchar2(20)
Bk_DateTime
Ps_age number(10) DepartingAirport_ID varchar2(20)
Ps_address varchar2(20) FK Fl_ID number(10)
Ps_gender varchar2(20) FK Bk_ID number(10)
FK Cn_ID number(10)

Cancel
PK Cancel number(10)
RM
FK Ps_ID number(10)
PK_FK1 Tc_ID number(10)
PK_FK2 Py_ID number(10)
Class
PK Class_id number(10)
Class_Number number(10) Payment
PK Py_ID number(10)
Ps_name varchar2(20)
Coust number(10)
Flight
Plean PK Fl_id number(10)
PK Pl_ID number(10) Fl_name varchar2(20)
Pl_name varchar2(20) Fl_time date
Pl_model varchar2(20) FK Plean_id number(10)
NumberOfSeat number(10) FK Class_ID number(10)

Assignment 2
No ratings yet
Assignment 2
16 pages
Tables
No ratings yet
Tables
2 pages
Tables
No ratings yet
Tables
2 pages
Project1 ERD-1
No ratings yet
Project1 ERD-1
1 page
Dbms Lab
No ratings yet
Dbms Lab
32 pages
Airplane
No ratings yet
Airplane
12 pages
Create Database Flight - Management
No ratings yet
Create Database Flight - Management
5 pages
Dbms Record
No ratings yet
Dbms Record
131 pages
SQL Table Creation Guide
No ratings yet
SQL Table Creation Guide
13 pages
Dbmsproject Info
No ratings yet
Dbmsproject Info
5 pages
Project 1 Erd
No ratings yet
Project 1 Erd
1 page
Airline Reservation System: Project Report For
No ratings yet
Airline Reservation System: Project Report For
63 pages
Airline: Name:K.Kartik REGNO:15MIS1105
No ratings yet
Airline: Name:K.Kartik REGNO:15MIS1105
5 pages
Flight Insert Query
No ratings yet
Flight Insert Query
4 pages
Database Management System Lab Assignment-1
No ratings yet
Database Management System Lab Assignment-1
21 pages
PROJECTDBMS
No ratings yet
PROJECTDBMS
4 pages
Worksheet Template DBMS
No ratings yet
Worksheet Template DBMS
5 pages
Dbms Practical 2
No ratings yet
Dbms Practical 2
6 pages
Airlines Reservation Database Design: Project
No ratings yet
Airlines Reservation Database Design: Project
11 pages
Worksheet Template DBMS
No ratings yet
Worksheet Template DBMS
5 pages
Flight Management System Query With Answer
100% (2)
Flight Management System Query With Answer
3 pages
Airline Reservation
No ratings yet
Airline Reservation
32 pages
Airline Reservation System Design
No ratings yet
Airline Reservation System Design
8 pages
SQL
No ratings yet
SQL
5 pages
Experiment-3: Name:-Shubham Shah Rollno: - 52 Div:-SE3 - D Subject:-DBMS
No ratings yet
Experiment-3: Name:-Shubham Shah Rollno: - 52 Div:-SE3 - D Subject:-DBMS
15 pages
Cycle Sheet 1: Name: P. Mahitha REG NO.: 17MIS0458 SLOT: L1+L2 Faculty: Prof. Jayaram Reddy
No ratings yet
Cycle Sheet 1: Name: P. Mahitha REG NO.: 17MIS0458 SLOT: L1+L2 Faculty: Prof. Jayaram Reddy
46 pages
SQL Training: Course-End Project Problem Statement
No ratings yet
SQL Training: Course-End Project Problem Statement
5 pages
Hotel Database
No ratings yet
Hotel Database
6 pages
Database Project for Students
No ratings yet
Database Project for Students
21 pages
Airline Reservation System
No ratings yet
Airline Reservation System
11 pages
I. To Create Database Customer Table: Problem 1
No ratings yet
I. To Create Database Customer Table: Problem 1
26 pages
DBMS Assignment 4
No ratings yet
DBMS Assignment 4
14 pages
SQL Project 4
No ratings yet
SQL Project 4
2 pages
DBMS Lab Record - Sandeep
No ratings yet
DBMS Lab Record - Sandeep
27 pages
DBMS Cat1
No ratings yet
DBMS Cat1
25 pages
SQL Assignment
No ratings yet
SQL Assignment
9 pages
Flight Booking SQL Project
No ratings yet
Flight Booking SQL Project
4 pages
Online Airlines Reservation - 24
No ratings yet
Online Airlines Reservation - 24
13 pages
Dbms Lab Assignment: Name: Adarsh Kashyap Reg. No.: 2020UGCS064
No ratings yet
Dbms Lab Assignment: Name: Adarsh Kashyap Reg. No.: 2020UGCS064
2 pages
DBMS Lab Exercises for Students
No ratings yet
DBMS Lab Exercises for Students
24 pages
SQL Project 2
No ratings yet
SQL Project 2
3 pages
Tables of Fly High
No ratings yet
Tables of Fly High
2 pages
Database and Table Creation
No ratings yet
Database and Table Creation
4 pages
Flight Info System for Developers
100% (1)
Flight Info System for Developers
7 pages
Flightid Flightnameid Locationid Time Flightclass Price Date Flightname Time
No ratings yet
Flightid Flightnameid Locationid Time Flightclass Price Date Flightname Time
7 pages
Mkdkaz Null 2023-09-01 0712140600231 NULL Mkdkaz Null 2023-09-01 0712140600231 NULL
No ratings yet
Mkdkaz Null 2023-09-01 0712140600231 NULL Mkdkaz Null 2023-09-01 0712140600231 NULL
12 pages
Course-End Project: Air Cargo Analysis: Problem Statement Scenario
No ratings yet
Course-End Project: Air Cargo Analysis: Problem Statement Scenario
10 pages
Shashwat (20mis0255)
No ratings yet
Shashwat (20mis0255)
7 pages
AirIndia Design
No ratings yet
AirIndia Design
13 pages
SQL Database Schema for Booking System
No ratings yet
SQL Database Schema for Booking System
3 pages
Travel Database Schema Overview
No ratings yet
Travel Database Schema Overview
8 pages
Table For Back End: Table Name User Profile
No ratings yet
Table For Back End: Table Name User Profile
26 pages
DDL Statement
No ratings yet
DDL Statement
5 pages
1 User App DBMS
No ratings yet
1 User App DBMS
54 pages
SQL
No ratings yet
SQL
2 pages
Train Reservation
No ratings yet
Train Reservation
4 pages
Cybersecurity Strategies33
No ratings yet
Cybersecurity Strategies33
1 page
SIENS14
No ratings yet
SIENS14
1 page
Cybersecurity Strategies26
No ratings yet
Cybersecurity Strategies26
1 page
SIENS7
No ratings yet
SIENS7
1 page
Cybersecurity Strategies4
No ratings yet
Cybersecurity Strategies4
1 page
Cybersecurity Strategies11
No ratings yet
Cybersecurity Strategies11
1 page
A Systematic Literature Review On Phishing and
No ratings yet
A Systematic Literature Review On Phishing and
6 pages
Emran
No ratings yet
Emran
1 page
AREA RULE::::::: Description
100% (1)
AREA RULE::::::: Description
7 pages
"Ejection Seat": Department of Mechanical Engineering
100% (1)
"Ejection Seat": Department of Mechanical Engineering
25 pages
Pilots: Mastering Emergency Glides
100% (1)
Pilots: Mastering Emergency Glides
5 pages
SACAA Air Law and Procedures
No ratings yet
SACAA Air Law and Procedures
21 pages
Pilot Training Entry Form
No ratings yet
Pilot Training Entry Form
3 pages
Saitek X55 F-16C Profile by IdefixRC
No ratings yet
Saitek X55 F-16C Profile by IdefixRC
1 page
Pilot 53in Sbach 342 Manual
No ratings yet
Pilot 53in Sbach 342 Manual
23 pages
Far 121& PDF
No ratings yet
Far 121& PDF
342 pages
Uld
No ratings yet
Uld
6 pages
Itinerary OTIWYL
No ratings yet
Itinerary OTIWYL
2 pages
LEVC
No ratings yet
LEVC
39 pages
Vistara Boarding Pass
No ratings yet
Vistara Boarding Pass
3 pages
Milestone Case Histories in Aircraft Structural Integrity
100% (1)
Milestone Case Histories in Aircraft Structural Integrity
25 pages
Emirates e Tickets Example
100% (3)
Emirates e Tickets Example
1 page
A320 Characteristic Airport and Maintenance Planning PDF
No ratings yet
A320 Characteristic Airport and Maintenance Planning PDF
429 pages
FOCA GM INFO Conduct of PC LPC OPC and LC in Multi Pilot Operation 2018.11.0111
No ratings yet
FOCA GM INFO Conduct of PC LPC OPC and LC in Multi Pilot Operation 2018.11.0111
9 pages
Qatar Airways E-Ticket Details
No ratings yet
Qatar Airways E-Ticket Details
1 page
Rotate MD-11 Tutorial Flight (Xplane 11)
No ratings yet
Rotate MD-11 Tutorial Flight (Xplane 11)
37 pages
Ata 4 Beechcraft b200
No ratings yet
Ata 4 Beechcraft b200
34 pages
Title: Placards and Markings - Interior Placards and Markings - Install Bilingual Cargo Compartment Placards and Signs, English Below As 2Nd Language
No ratings yet
Title: Placards and Markings - Interior Placards and Markings - Install Bilingual Cargo Compartment Placards and Signs, English Below As 2Nd Language
38 pages
Level Flight Lesson Plan
No ratings yet
Level Flight Lesson Plan
3 pages
WMKI
No ratings yet
WMKI
16 pages
ROK Military UAV Certification
No ratings yet
ROK Military UAV Certification
22 pages
Louie S. Segovia: Contact
No ratings yet
Louie S. Segovia: Contact
2 pages
Plans - Telemaster
100% (1)
Plans - Telemaster
37 pages
NF72696158739473 E-Ticket PDF
No ratings yet
NF72696158739473 E-Ticket PDF
2 pages
Tel: (201) 777 2900. Applications and Projects Agusta Model 206A & A-L Jetranger
No ratings yet
Tel: (201) 777 2900. Applications and Projects Agusta Model 206A & A-L Jetranger
1 page
A380 Technical Training Manual Maintenance Course - T1 & T2 (RR / Metric) LEVEL II - ATA 26 Fire Protection Systems
100% (2)
A380 Technical Training Manual Maintenance Course - T1 & T2 (RR / Metric) LEVEL II - ATA 26 Fire Protection Systems
52 pages
08052024-Airports - SOP
No ratings yet
08052024-Airports - SOP
13 pages
Winter Operation Guide
100% (2)
Winter Operation Guide
126 pages

Airline Database Schema Overview

Uploaded by

Airline Database Schema Overview

Uploaded by

Passengers Ticket

PK Ps_ID number(10) Booking PK Tc_ID number(10)

You might also like