-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathphase3.sql
120 lines (111 loc) · 26.5 KB
/
phase3.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
INSERT INTO `airport_db`.`Airport` (`IATA airport codes`, `Altitude`, `Time Zone`, `Airport Name`, `City`, `Country`, `Latitude`, `Longitude`) VALUES ('DEL', '225', '+05:30', 'Indira Gandhi International Airport', 'Delhi', 'India', '28.7041', '77.1025');
INSERT INTO `airport_db`.`Airport` (`IATA airport codes`, `Altitude`, `Time Zone`, `Airport Name`, `City`, `Country`, `Latitude`, `Longitude`) VALUES ('HYD', '542', '+05:30', 'Rajiv Gandhi International Airport', 'Hyderabad', 'India', '17.385', '78.4867');
INSERT INTO `airport_db`.`Airport` (`IATA airport codes`, `Altitude`, `Time Zone`, `Airport Name`, `City`, `Country`, `Latitude`, `Longitude`) VALUES ('MUM', '14', '+05:30', 'Chattrapati Shivaji International Airport', 'Mumbai', 'India', '19.076', '72.8777');
INSERT INTO `airport_db`.`Airport` (`IATA airport codes`, `Altitude`, `Time Zone`, `Airport Name`, `City`, `Country`, `Latitude`, `Longitude`) VALUES ('BLR', '920', '+05:30', 'KempeGowda International Airport', 'Bengaluru', 'India', '12.9716', '77.5946');
INSERT INTO `airport_db`.`Runway` (`fk_to_airport_IATA_airport_codes`, `Runway ID`, `length_ft`, `width_ft`, `Status`) VALUES ('BLR', '0', '13123', '148', 'Available');
INSERT INTO `airport_db`.`Runway` (`fk_to_airport_IATA_airport_codes`, `Runway ID`, `length_ft`, `width_ft`, `Status`) VALUES ('BLR', '1', '13120', '200', 'Available');
INSERT INTO `airport_db`.`Runway` (`fk_to_airport_IATA_airport_codes`, `Runway ID`, `length_ft`, `width_ft`, `Status`) VALUES ('DEL', '0', '9229', '150.9', 'Available');
INSERT INTO `airport_db`.`Runway` (`fk_to_airport_IATA_airport_codes`, `Runway ID`, `length_ft`, `width_ft`, `Status`) VALUES ('DEL', '1', '12500', '150.92', 'Available');
INSERT INTO `airport_db`.`Runway` (`fk_to_airport_IATA_airport_codes`, `Runway ID`, `length_ft`, `width_ft`, `Status`) VALUES ('DEL', '2', '14534.121', '196.85', 'Available');
INSERT INTO `airport_db`.`Runway` (`fk_to_airport_IATA_airport_codes`, `Runway ID`, `length_ft`, `width_ft`, `Status`) VALUES ('HYD', '0', '12162', '148', 'Available');
INSERT INTO `airport_db`.`Runway` (`fk_to_airport_IATA_airport_codes`, `Runway ID`, `length_ft`, `width_ft`, `Status`) VALUES ('HYD', '1', '13980', '200', 'Available');
INSERT INTO `airport_db`.`Runway` (`fk_to_airport_IATA_airport_codes`, `Runway ID`, `length_ft`, `width_ft`, `Status`) VALUES ('HYD', '2', '3622', '98', 'Disfunctional');
INSERT INTO `airport_db`.`Runway` (`fk_to_airport_IATA_airport_codes`, `Runway ID`, `length_ft`, `width_ft`, `Status`) VALUES ('MUM', '0', '12008', '200', 'Available');
INSERT INTO `airport_db`.`Runway` (`fk_to_airport_IATA_airport_codes`, `Runway ID`, `length_ft`, `width_ft`, `Status`) VALUES ('MUM', '1', '9810', '148', 'Available');
INSERT INTO `airport_db`.`Runway` (`fk_to_airport_IATA_airport_codes`, `Runway ID`, `length_ft`, `width_ft`, `Status`) VALUES ('MUM', '2', '334', '567', 'Disfunctional');
INSERT INTO `airport_db`.`Terminal` (`fk_to_airport_IATA_airport_codes`, `Terminal ID`, `Airplane Handling capacity`, `Floor Area`) VALUES ('DEL', '1', '450', '34753');
INSERT INTO `airport_db`.`Terminal` (`fk_to_airport_IATA_airport_codes`, `Terminal ID`, `Airplane Handling capacity`, `Floor Area`) VALUES ('DEL', '2', '280', '54320');
INSERT INTO `airport_db`.`Terminal` (`fk_to_airport_IATA_airport_codes`, `Terminal ID`, `Airplane Handling capacity`, `Floor Area`) VALUES ('DEL', '3', '800', '76459');
INSERT INTO `airport_db`.`Terminal` (`fk_to_airport_IATA_airport_codes`, `Terminal ID`, `Airplane Handling capacity`, `Floor Area`) VALUES ('MUM', '1', '325', '21457');
INSERT INTO `airport_db`.`Terminal` (`fk_to_airport_IATA_airport_codes`, `Terminal ID`, `Airplane Handling capacity`, `Floor Area`) VALUES ('MUM', '2', '341', '23574');
INSERT INTO `airport_db`.`Terminal` (`fk_to_airport_IATA_airport_codes`, `Terminal ID`, `Airplane Handling capacity`, `Floor Area`) VALUES ('MUM', '3', '560', '87934');
INSERT INTO `airport_db`.`Terminal` (`fk_to_airport_IATA_airport_codes`, `Terminal ID`, `Airplane Handling capacity`, `Floor Area`) VALUES ('HYD', '1', '560', '23572');
INSERT INTO `airport_db`.`Terminal` (`fk_to_airport_IATA_airport_codes`, `Terminal ID`, `Airplane Handling capacity`, `Floor Area`) VALUES ('HYD', '2', '960', '46973');
INSERT INTO `airport_db`.`Terminal` (`fk_to_airport_IATA_airport_codes`, `Terminal ID`, `Airplane Handling capacity`, `Floor Area`) VALUES ('BLR', '1', '650', '23258');
INSERT INTO `airport_db`.`Terminal` (`fk_to_airport_IATA_airport_codes`, `Terminal ID`, `Airplane Handling capacity`, `Floor Area`) VALUES ('BLR', '2', '860', '143766');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('956655099681', 'DEL', 'MAUREEN', 'DA', 'CHIAVOLA', '18', '50667', 'Indian', '1986-8-21', 'Female', '956655099681');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('998808524131', 'MUM', 'MCKAY', 'VA', 'MURPHY', '22', '71457', 'Indian', '2013-2-28', 'Male', '998808524131');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('999820913949', 'BLR', 'HERMAN', 'AA', 'JOHNSON', '25', '33870', 'Indian', '2013-11-6', 'Male', '999820913949');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('815733892734', 'HYD', 'MARGARET', 'A', 'GAECKE', '21', '20566', 'Indian', '1992-8-6', 'Female', '815733892734');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('776852249050', 'DEL', 'CHRISTOPHER', 'AA', 'HAMMONDS', '9', '65174', 'Indian', '2020-7-24', 'Male', '956655099681');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('815389550189', 'MUM', 'BRYANT', 'A', 'HOGAN', '11', '93237', 'Indian', '1985-3-8', 'Male', '998808524131');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('815733892733', 'HYD', 'XUAN', 'A', 'LE', '12', '69207', 'Indian', '1978-4-3', 'Female', '815733892734');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('817550895816', 'BLR', 'ANTHONY', 'RA', 'LIN', '12', '61042', 'Indian', '1971-6-19', 'Male', '999820913949');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('419931616553', 'DEL', 'SANDRA', 'A', 'GARNER', '4', '43389', 'Indian', '1961-7-19', 'Female', '776852249050');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('436837066216', 'MUM', 'BIANCA', 'A', 'GLASS', '4', '74604', 'Indian', '2019-10-12', 'Male', '815389550189');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('443459752216', 'BLR', 'TYNEASHA', 'A', 'MURCHISON', '4', '17674', 'Indian', '1988-2-25', 'Female', '817550895816');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('450805939067', 'HYD', 'JULIO', 'MA', 'PANTOJA', '4', '14986', 'Indian', '1984-1-16', 'Male', '815733892733');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('137979359058', 'DEL', 'VERNICA', 'LA', 'MORRIS', '0', '20566', 'Indian', '2010-4-17', 'Female', '419931616553');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('144269786726', 'DEL', 'BRUCE', 'SA', 'ADELMAN', '0', '71457', 'Indian', '1975-3-8', 'Male', '419931616553');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('149655844898', 'DEL', 'MAYRA', 'MA', 'MUNOZ', '0', '33870', 'Indian', '1961-9-11', 'Female', '419931616553');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('159961373889', 'DEL', 'BRITTANY', 'AA', 'BURKS', '1', '20566', 'Indian', '1953-10-18', 'Female', '419931616553');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('183207521309', 'HYD', 'BARBARA', 'AA', 'BERONSKI', '1', '71457', 'Indian', '1986-3-18', 'Female', '450805939067');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('190030951732', 'HYD', 'THOMAS', 'EA', 'MYLES', '1', '33870', 'Indian', '1990-1-17', 'Male', '450805939067');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('199286222027', 'HYD', 'DOROTHY', 'IA', 'DUKES', '2', '20566', 'Indian', '1957-8-2', 'Female', '450805939067');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('233167041254', 'MUM', 'CLARA', 'AA', 'GERDES', '2', '71457', 'Indian', '1984-10-20', 'Female', '436837066216');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('244106032061', 'MUM', 'RALPH', 'CA', 'BAKER JR', '2', '33870', 'Indian', '2008-5-27', 'Male', '436837066216');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('247638008710', 'MUM', 'KAREN', 'SA', 'BOYD-GREATHOUSE', '2', '92327', 'Indian', '1950-1-3', 'Male', '436837066216');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('261514501173', 'BLR', 'RACHEL', 'EA', 'BROWN', '3', '18430', 'Indian', '2004-1-8', 'Female', '443459752216');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('277990544656', 'BLR', 'GISELLE', 'AA', 'CALDERON', '3', '65174', 'Indian', '1961-2-12', 'Male', '443459752216');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('373724464459', 'BLR', 'ANGELA', 'CA', 'CEREZO', '3', '93237', 'Indian', '1994-9-6', 'Female', '443459752216');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('375299003172', 'DEL', 'CHERYL', 'RA', 'DAVIS', '3', '69207', 'Indian', '1958-11-5', 'Female', '419931616553');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('383457629189', 'DEL', 'MONICA', 'MA', 'GARCIA', '3', '61042', 'Indian', '1973-5-10', 'Female', '419931616553');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('517745328168', 'DEL', 'ARTEE', 'A', 'PITTMAN', '5', '50667', 'Indian', '2003-4-1', 'Male', '956655099681');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('521624019670', 'MUM', 'ENRIQUE', 'A', 'RUIZ', '5', '20566', 'Indian', '1971-2-6', 'Male', '998808524131');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('540584527686', 'BLR', 'BRIDGETT', 'PA', 'SHORTER', '6', '71457', 'Indian', '1988-1-22', 'Male', '999820913949');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('551395948759', 'HYD', 'DWAYNE', 'JA', 'VALENTINE', '7', '33870', 'Indian', '1950-9-22', 'Male', '815733892734');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('563847876190', 'DEL', 'MYRNA', 'A', 'WEBB', '7', '20566', 'Indian', '1958-12-14', 'Male', '956655099681');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('572875339270', 'DEL', 'ARION', 'RA', 'BROWN', '7', '71457', 'Indian', '2001-7-11', 'Female', '956655099681');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('652320097439', 'MUM', 'BETTY', 'A', 'FLETCHER', '8', '33870', 'Indian', '1997-1-14', 'Female', '998808524131');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('654337056688', 'BLR', 'MARIO', 'A', 'GARCIA', '8', '20566', 'Indian', '2005-12-26', 'Female', '999820913949');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('654630609952', 'HYD', 'JUDITH', 'A', 'TOLLINCHI', '9', '71457', 'Indian', '2001-10-1', 'Female', '815733892734');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('723457504496', 'DEL', 'STANLEY', 'A', 'DANIEL', '9', '33870', 'Indian', '2015-9-11', 'Male', '956655099681');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('771582198504', 'BLR', 'ANTONIO', 'SA', 'AMARO', '9', '92327', 'Indian', '2008-10-3', 'Male', '999820913949');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('774572687679', 'MUM', 'DAVID', 'MA', 'BEHLING', '9', '18430', 'Indian', '1957-2-6', 'Male', '998808524131');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('836429038835', 'HYD', 'MICHAEL', 'LA', 'MOORE', '14', '43389', 'Indian', '1992-9-20', 'Male', '815733892734');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('856067038076', 'DEL', 'JESUS', 'A', 'ONTIVEROS', '15', '74604', 'Indian', '1960-12-4', 'Male', '956655099681');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('878403070017', 'MUM', 'SHERRY', 'A', 'ZABEL', '15', '17674', 'Indian', '1962-11-4', 'Female', '998808524131');
INSERT INTO `airport_db`.`Airport Employees/CREWS` (`Aadhar_card_number`, `fk_to_airport_IATA_code_of_employing_airport`, `First Name`, `Middle Name`, `Last Name`, `Experience`, `Salary`, `Nationality`, `DOB`, `Gender`, `sup_Aadhar_card_number`) VALUES ('952765772249', 'HYD', 'GILBERTO', 'KA', 'PEREZ-PADILLA', '18', '14986', 'Indian', '1970-8-4', 'Male', '815733892734');
INSERT INTO `airport_db`.`mo_executives` (`fk_to_airport_crew_aadhar_card_number`, `Job title`) VALUES ('572875339270', 'Management Operations');
INSERT INTO `airport_db`.`mo_executives` (`fk_to_airport_crew_aadhar_card_number`, `Job title`) VALUES ('652320097439', 'Management Operations');
INSERT INTO `airport_db`.`mo_executives` (`fk_to_airport_crew_aadhar_card_number`, `Job title`) VALUES ('654337056688', 'Management Operations');
INSERT INTO `airport_db`.`mo_executives` (`fk_to_airport_crew_aadhar_card_number`, `Job title`) VALUES ('654630609952', 'Management Operations');
INSERT INTO `airport_db`.`mo_executives` (`fk_to_airport_crew_aadhar_card_number`, `Job title`) VALUES ('723457504496', 'Management Operations');
INSERT INTO `airport_db`.`mo_executives` (`fk_to_airport_crew_aadhar_card_number`, `Job title`) VALUES ('771582198504', 'Management Operations');
INSERT INTO `airport_db`.`mo_executives` (`fk_to_airport_crew_aadhar_card_number`, `Job title`) VALUES ('774572687679', 'Management Operations');
INSERT INTO `airport_db`.`mo_executives` (`fk_to_airport_crew_aadhar_card_number`, `Job title`) VALUES ('836429038835', 'Management Operations');
INSERT INTO `airport_db`.`mo_executives` (`fk_to_airport_crew_aadhar_card_number`, `Job title`) VALUES ('856067038076', 'Management Operations');
INSERT INTO `airport_db`.`mo_executives` (`fk_to_airport_crew_aadhar_card_number`, `Job title`) VALUES ('878403070017', 'Management Operations');
INSERT INTO `airport_db`.`mo_executives` (`fk_to_airport_crew_aadhar_card_number`, `Job title`) VALUES ('952765772249', 'Management Operations');
INSERT INTO `airport_db`.`mo_executives` (`fk_to_airport_crew_aadhar_card_number`, `Job title`) VALUES ('956655099681', 'Chief Manager');
INSERT INTO `airport_db`.`mo_executives` (`fk_to_airport_crew_aadhar_card_number`, `Job title`) VALUES ('815733892733', 'Chief Manager');
INSERT INTO `airport_db`.`mo_executives` (`fk_to_airport_crew_aadhar_card_number`, `Job title`) VALUES ('998808524131', 'Chief Manager');
INSERT INTO `airport_db`.`mo_executives` (`fk_to_airport_crew_aadhar_card_number`, `Job title`) VALUES ('999820913949', 'Chief Manager');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('137979359058', 'Security', '1');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('144269786726', 'Security', '2');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('149655844898', 'Security', '3');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('159961373889', 'Security', '4');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('183207521309', 'Security', '5');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('190030951732', 'Security', '6');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('199286222027', 'Security', '7');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('233167041254', 'Security', '8');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('244106032061', 'Security', '9');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('247638008710', 'Security', '10');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('261514501173', 'Security', '11');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('277990544656', 'Security', '12');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('373724464459', 'Security', '13');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('375299003172', 'Security', '14');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('383457629189', 'Security', '15');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('419931616553', 'Security Supervisor', '16');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('436837066216', 'Security Supervisor', '17');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('443459752216', 'Security Supervisor', '18');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('450805939067', 'Security Supervisor', '19');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('776852249050', 'Security Incharge', '20');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('815389550189', 'Security Incharge', '21');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('815733892733', 'Security Incharge', '22');
INSERT INTO `airport_db`.`Security` (`fk_to_airport_crew_aadhar_card_number`, `Designation`, `Security ID number`) VALUES ('817550895816', 'Security Incharge', '23');
INSERT INTO `airport_db`.`air_traffic_controller` (`fk_to_airport_crew_aadhar_card_number`, `Current communication Frequency`, `Training/Education`) VALUES ('517745328168', '560', 'MS');
INSERT INTO `airport_db`.`air_traffic_controller` (`fk_to_airport_crew_aadhar_card_number`, `Current communication Frequency`, `Training/Education`) VALUES ('521624019670', '786', 'Btech');
INSERT INTO `airport_db`.`air_traffic_controller` (`fk_to_airport_crew_aadhar_card_number`, `Current communication Frequency`, `Training/Education`) VALUES ('540584527686', '675', 'Mtech');
INSERT INTO `airport_db`.`air_traffic_controller` (`fk_to_airport_crew_aadhar_card_number`, `Current communication Frequency`, `Training/Education`) VALUES ('551395948759', '956', 'Btech');
INSERT INTO `airport_db`.`air_traffic_controller` (`fk_to_airport_crew_aadhar_card_number`, `Current communication Frequency`, `Training/Education`) VALUES ('563847876190', '842', 'PhD');