March 18th, 2019 
adminhere is the SQL. PLEASE ONLY START FROM # 6 TO #10AS I DID #1 TO #5
# Code to create Airlines_2175 database for DATA 620
# Contains updated data line as follows:
# Updated 5/17/2017 by Carrie Beam (rolled forward to 2017)
Drop Database if exists airlines;
CREATE DATABASE Airlines;
USE Airlines;
# USE Airlines ; # this is the old one also
— A carrier is a commercial company offering flights to the public
CREATE TABLE Carriers (
Carrier_ID INTEGER PRIMARY KEY AUTO_INCREMENT
Carrier_Name VARCHAR(20)
);
— One carrier can fly many types of aircraft
CREATE TABLE Aircraft (
Plane_ID INTEGER PRIMARY KEY AUTO_INCREMENT
Manufacturer VARCHAR(10)
Model_Num VARCHAR(20)
Original_Purchase_Date DATE
Last_Service DATE
Carrier_ID INTEGER
Number_of_Seats INTEGER
FOREIGN KEY (Carrier_ID) REFERENCES Carriers(Carrier_ID)
);
— One airport facilitates many flights
CREATE TABLE Airports (
Airport_Code VARCHAR(3) PRIMARY KEY
Airport_Location VARCHAR(25)
Year_Opened INTEGER
Num_of_Terminals INTEGER
);
— Each flight involves many airports
CREATE TABLE Flights (
Flight_ID INTEGER PRIMARY KEY AUTO_INCREMENT
Plane_ID INTEGER
Carrier_ID INTEGER
Airport_Code_Origin VARCHAR(3)
Airport_Code_Destination VARCHAR(3)
Departure_DateTime DATETIME
Arrival_DateTime DATETIME
FOREIGN KEY (Plane_ID) REFERENCES Aircraft(Plane_ID)
/* FOREIGN KEY (Carrier_ID) REFERENCES Carriers(Carrier_ID) */
FOREIGN KEY (Airport_Code_Origin) REFERENCES Airports(Airport_Code)
FOREIGN KEY (Airport_Code_Destination) REFERENCES Airports(Airport_Code)
);
— Adding records to the carriers table
INSERT INTO Carriers (Carrier_Name)
VALUES (‘American’)
(‘Delta’)
(‘Southwest’)
(‘United’)
(‘Virgin Atlantic’);
— Adding records to the aircraft table
INSERT INTO Aircraft (Manufacturer Model_Num Original_Purchase_Date Last_Service Carrier_ID)
VALUES
(‘Boeing”787 Dreamliner”2014-10-10”2015-12-17’3)
(‘Boeing”737-900”2003-03-23”2016-01-26’3)
(‘Embraer”RJ-45”1999-11-24”2016-01-31’3)
(‘Embraer”RJ-45”2002-10-02”2016-01-20’1)
(‘Boeing”737-900”2000-04-16”2015-12-24’2)
(‘Boeing”747-400”2001-10-25”2016-01-03’3)
(‘Boeing”737-900”2009-12-02”2016-01-26’3)
(‘Boeing”747-400”2005-05-14”2016-01-21’2)
(‘Boeing”737-900”1999-10-20”2015-12-27’5)
(‘Embraer”RJ-45”2009-05-05”2016-01-20’3)
(‘Airbus”A300”1999-11-25”2016-01-03’3)
(‘Embraer”RJ-45”2012-06-12”2016-01-17’2)
(‘Embraer”RJ-45”2014-12-01”2015-12-29’1)
(‘Boeing”737-900”2007-11-24”2016-01-07’1)
(‘Embraer”RJ-45”2000-08-31”2016-01-08’2)
(‘Airbus”A300”2011-11-11”2016-01-01’1)
(‘Boeing”747-400”2008-06-27”2015-12-09’1)
(‘Embraer”RJ-45”2008-11-25”2016-01-27’1)
(‘Airbus”A330”2013-03-27”2015-12-23’5)
(‘Embraer”RJ-45”2000-07-15”2016-01-13’3)
(‘Boeing”747-400”2001-12-05”2015-12-06’2)
(‘Boeing”737-900”2013-02-14”2015-12-16’2)
(‘Boeing”727-200”2008-08-21”2016-01-20’1)
(‘Airbus”A330”2001-12-02”2015-12-16’5)
(‘Embraer”RJ-45”2008-02-18”2016-01-08’3)
(‘Boeing”737-900”2007-04-02”2015-12-19’4)
(‘Embraer”RJ-45”2005-12-22”2016-01-16’1);
— Adding records to the Airports table
INSERT INTO Airports (Airport_Code Airport_Location Year_Opened Num_of_Terminals)
VALUES
(‘BOI”Boise ID’19363)
(‘ATL”Atlanta GA’19269)
(‘SLC”Salt Lake City UT’19335)
(‘LAX”Los Angeles CA’192810)
(‘SEA”Seattle WA’19446)
(‘MIA”Miami FL’19459)
(‘ORD”Chicago IL’19428)
(‘JFK”New York New York’194312)
(‘DFW”Dallas-Fort Worth TX’19738)
(‘LAS”Las Vegas NV’19473)
(‘MCO”Orlando FL’19424)
(‘JAX”Jacksonville FL’19683)
(‘PIT”Pittsburgh PA’19464)
(‘PHL”Philadelphia PA’19276)
(‘SFO”San Francisco CA’19278)
(‘IAH”Houston TX’195710);
— Adding records to the Flights table
INSERT INTO Flights (Plane_ID Carrier_ID Airport_Code_Origin Airport_Code_Destination Departure_DateTime Arrival_DateTime)
VALUES
(224’ORD”PIT”2017-01-20 20:39”2017-01-21 00:46′)
(224’IAH”PIT”2017-12-21 17:32”2017-12-21 19:35′)
(75’MIA”JFK”2017-02-20 23:26”2017-02-21 04:04′)
(14’MCO”BOI”2017-12-25 01:26”2017-12-25 06:16′)
(244’PIT”JFK”2017-12-17 21:20”2017-12-18 03:01′)
(212’MIA”SFO”2017-02-19 19:09”2017-02-19 19:38′)
(63’SFO”PIT”2017-02-21 21:45”2017-02-21 23:18′)
(235’JFK”DFW”2017-02-13 09:10”2017-02-13 10:59′)
(142’MCO”SEA”2017-12-07 02:57”2017-12-07 03:00′)
(265’BOI”PIT”2017-02-27 18:07”2017-02-28 01:18′)
(192’SEA”BOI”2017-12-29 05:49”2017-12-29 07:56′)
(184’PIT”ORD”2017-01-15 16:36”2017-01-15 18:22′)
(155’SFO”SEA”2017-01-15 01:55”2017-01-15 05:03′)
(41’ORD”LAS”2017-05-28 21:03”2017-05-29 00:34′)
(243’BOI”DFW”2017-02-23 06:50”2017-02-23 08:57′)
(64’SFO”JFK”2017-06-24 23:06”2017-06-25 04:25′)
(221’SFO”LAS”2017-01-03 01:05”2017-01-03 02:59′)
(73’MIA”SFO”2017-06-21 08:55”2017-06-21 09:11′)
(72’IAH”LAS”2017-01-10 10:42”2017-01-10 11:19′)
(83’LAX”ATL”2017-07-27 09:35”2017-07-27 11:05′)
(263’SFO”DFW”2017-08-07 08:05”2017-08-07 11:24′)
(204’JFK”ORD”2017-01-04 12:45”2017-01-04 15:41′)
(273’ORD”ATL”2017-10-02 05:42”2017-10-02 07:18′)
(73’ORD”DFW”2017-09-09 04:40”2017-09-09 05:13′)
(101’PIT”JFK”2017-02-14 07:19”2017-02-14 10:43′)
(134’LAX”JFK”2017-07-18 18:23”2017-07-18 21:05′)
(184’PHL”MCO”2017-01-30 13:47”2017-01-30 16:49′)
(85’JFK”PHL”2017-07-01 18:57”2017-07-01 19:04′)
(265’SEA”SLC”2017-08-08 05:19”2017-08-08 05:48′)
(234’MIA”LAX”2017-11-26 18:16”2017-11-26 23:35′)
(175’MCO”SLC”2017-03-06 11:32”2017-03-06 12:38′)
(23’JAX”PIT”2017-03-04 13:16”2017-03-04 13:32′)
(232’IAH”DFW”2017-03-02 21:47”2017-03-03 00:29′)
(175’LAX”SFO”2017-04-01 00:07”2017-04-01 02:25′)
(74’JAX”LAX”2017-12-17 15:46”2017-12-17 18:00′)
(91’JAX”PIT”2017-05-20 17:09”2017-05-20 17:28′)
(21’PIT”ATL”2017-12-21 09:02”2017-12-21 13:53′)
(44’SFO”DFW”2017-03-10 23:07”2017-03-11 03:33′)
(185’JAX”MCO”2017-02-07 10:59”2017-02-07 13:13′)
(41’ATL”PIT”2017-07-25 01:57”2017-07-25 03:25′)
(52’LAX”SEA”2017-12-09 18:29”2017-12-09 21:40′)
(275’JAX”ORD”2017-08-26 08:35”2017-08-26 14:25′)
(64’MIA”IAH”2017-03-17 05:00”2017-03-17 08:24′)
(94’IAH”LAS”2017-09-21 10:23”2017-09-21 11:17′)
(111’ATL”PIT”2017-03-20 03:53”2017-03-20 04:36′)
(145’LAX”PIT”2017-01-21 03:15”2017-01-21 05:23′)
(215’ATL”SEA”2017-07-10 01:33”2017-07-10 04:07′)
(63’IAH”LAX”2017-02-09 16:59”2017-02-09 22:30′)
(232’PIT”MCO”2017-12-09 19:46”2017-12-09 20:43′)
(104’LAX”SLC”2017-08-06 09:30”2017-08-06 12:28′)
(215’BOI”PIT”2017-12-14 17:09”2017-12-14 20:07′)
(104’PIT”SLC”2017-02-08 02:18”2017-02-08 04:11′)
(41’LAS”DFW”2017-02-10 14:31”2017-02-10 16:37′)
(231’MCO”BOI”2017-01-18 21:56”2017-01-18 22:35′)
(212’SEA”JFK”2017-03-21 05:36”2017-03-21 10:02′)
(85’SLC”JFK”2017-04-21 03:19”2017-04-21 05:34′)
(271’JFK”SLC”2017-01-09 21:00”2017-01-10 01:37′)
(215’JFK”DFW”2017-02-08 18:47”2017-02-08 23:48′)
(72’IAH”SEA”2017-12-21 22:58”2017-12-22 01:54′)
(222’MCO”PHL”2017-01-08 05:07”2017-01-08 06:36′)
(183’LAS”BOI”2017-02-27 05:56”2017-02-27 09:42′)
(175’LAX”MIA”2017-03-24 16:42”2017-03-24 21:56′)
(44’MIA”JFK”2017-03-06 12:29”2017-03-06 15:01′)
(75’LAS”JAX”2017-07-08 04:57”2017-07-08 12:43′)
(115’DFW”ORD”2017-06-07 02:36”2017-06-07 07:13′)
(102’JAX”SFO”2017-02-12 04:31”2017-02-12 05:31′)
(273’PHL”JAX”2017-05-15 22:08”2017-05-15 23:43′)
(72’SFO”PHL”2017-11-20 04:39”2017-11-20 10:15′)
(255’JFK”IAH”2017-01-08 17:52”2017-01-08 19:48′)
(211’MIA”JAX”2017-10-07 07:59”2017-10-07 11:55′)
(191’SEA”BOI”2017-12-15 14:23”2017-12-15 18:05′)
(143’PHL”ORD”2017-11-23 19:03”2017-11-23 22:04′)
(92’SEA”BOI”2017-03-18 02:51”2017-03-18 05:07′)
(82’JAX”DFW”2017-07-13 02:15”2017-07-13 04:42′)
(204’MCO”DFW”2017-01-08 16:23”2017-01-08 17:19′)
(25’IAH”BOI”2017-07-10 16:26”2017-07-10 20:55′)
(274’LAX”ATL”2017-05-09 21:00”2017-05-09 23:11′)
(52’BOI”ORD”2017-03-29 13:24”2017-03-29 14:57′)
(113’LAX”ORD”2017-02-27 02:11”2017-02-27 04:08′)
(61’LAX”JAX”2017-02-01 10:30”2017-02-01 14:49′)
(11’BOI”LAX”2017-12-28 14:22”2017-12-28 16:57′)
(172’LAX”MCO”2017-08-22 08:12”2017-08-22 15:13′)
(134’MIA”ORD”2017-01-20 09:06”2017-01-20 12:52′)
(14’MIA”MCO”2017-09-28 11:55”2017-09-28 13:47′)
(272’BOI”JFK”2017-01-28 21:09”2017-01-28 23:46′)
(182’LAS”PHL”2017-02-21 12:51”2017-02-21 15:18′)
(52’PHL”LAS”2017-02-18 23:39”2017-02-19 00:12′)
(153’DFW”JAX”2017-12-09 00:11”2017-12-09 05:38′)
(51’ATL”MCO”2017-11-15 16:45”2017-11-15 20:41′)
(243’SEA”LAX”2017-01-27 12:37”2017-01-27 18:48′)
(161’MIA”LAS”2017-01-21 06:14”2017-01-21 11:55′)
(114’DFW”PIT”2017-01-29 06:05”2017-01-29 10:53′)
(43’IAH”JAX”2017-01-22 16:46”2017-01-23 00:12′)
(164’LAS”MCO”2017-07-31 07:57”2017-07-31 10:14′)
(154’IAH”ORD”2017-12-22 00:39”2017-12-22 02:25′)
(261’MIA”LAS”2017-01-05 01:12”2017-01-05 05:39′)
(54’IAH”LAS”2017-02-14 21:53”2017-02-15 02:00′)
(145’SEA”PIT”2017-02-11 08:56”2017-02-11 12:51′)
(155’BOI”MCO”2017-06-01 18:10”2017-06-01 22:26′)
(263’SEA”IAH”2017-07-12 08:30”2017-07-12 09:42′)
(251’DFW”PIT”2017-01-28 08:13”2017-01-28 11:05′)
(61’PHL”SEA”2017-01-21 22:12”2017-01-22 00:05′)
(75’LAS”JFK”2017-02-01 06:15”2017-02-01 10:08′)
(222’BOI”JFK”2017-01-30 08:07”2017-01-30 10:26′)
(201’MIA”JFK”2017-04-02 01:02”2017-04-02 01:32′)
(131’PHL”ATL”2017-08-09 18:29”2017-08-09 19:29′)
(185’DFW”JAX”2017-04-23 18:37”2017-04-24 00:01′)
(64’PIT”IAH”2017-01-12 11:30”2017-01-12 18:33′)
(105’MCO”ORD”2017-02-28 09:35”2017-02-28 13:05′)
(211’PIT”MIA”2017-01-31 00:46”2017-01-31 05:04′)
(14’JFK”MCO”2017-07-15 17:41”2017-07-15 23:21′)
(24’PHL”ORD”2017-03-15 06:52”2017-03-15 07:40′)
(203’PHL”ATL”2017-02-05 05:21”2017-02-05 06:18′)
(215’SEA”PHL”2017-02-18 00:10”2017-02-18 02:33′)
(192’SEA”MCO”2017-01-25 20:31”2017-01-25 21:36′)
(12’DFW”SFO”2017-11-04 15:58”2017-11-04 16:04′)
(121’ATL”JFK”2017-01-13 16:04”2017-01-13 21:30′)
(174’PHL”JAX”2017-01-08 20:32”2017-01-08 22:29′)
(42’ATL”SLC”2017-10-13 02:20”2017-10-13 06:18′)
(255’SFO”DFW”2017-12-28 02:57”2017-12-28 03:14′)
(205’SEA”PHL”2017-07-05 23:38”2017-07-06 00:24′)
(275’LAX”SEA”2017-12-15 04:35”2017-12-15 04:59′)
(93’PHL”JFK”2017-03-16 09:17”2017-03-16 11:14′)
(194’SLC”PIT”2017-02-01 12:28”2017-02-01 16:17′)
(162’JFK”PIT”2017-06-06 09:08”2017-06-06 13:25′)
(75’ATL”MIA”2017-12-08 20:15”2017-12-08 22:39′)
(234’SFO”SLC”2017-01-20 12:31”2017-01-20 16:18′)
(102’SFO”BOI”2017-05-03 01:50”2017-05-03 02:23′)
(263’LAS”PHL”2017-01-19 13:05”2017-01-19 13:10′)
(41’IAH”LAS”2017-08-31 16:08”2017-08-31 16:29′)
(215’JFK”SEA”2017-05-30 14:33”2017-05-30 15:25′)
(182’JFK”MIA”2017-02-11 12:29”2017-02-11 17:50′)
(42’PHL”ATL”2017-07-10 14:25”2017-07-10 21:58′)
(93’PIT”JAX”2017-03-22 20:06”2017-03-22 20:18′)
(45’BOI”SLC”2017-12-19 16:19”2017-12-19 18:18′)
(273’BOI”MIA”2017-12-11 09:09”2017-12-11 11:23′)
(41’BOI”JFK”2017-01-07 01:43”2017-01-07 04:36′)
(44’DFW”LAS”2017-01-02 22:45”2017-01-03 00:47′)
(85’JAX”ATL”2017-03-07 20:46”2017-03-07 23:58′)
(222’MCO”PHL”2017-04-15 07:05”2017-04-15 11:51′)
(141’SLC”PIT”2017-07-13 06:33”2017-07-13 09:57′)
(102’PHL”SLC”2017-01-02 04:21”2017-01-02 04:42′)
(93’SEA”MIA”2017-02-01 06:45”2017-02-01 10:15′)
(124’IAH”ORD”2017-07-09 00:37”2017-07-09 03:00′)
(135’BOI”SEA”2017-09-12 06:42”2017-09-12 10:14′)
(152’MCO”ATL”2017-01-13 18:32”2017-01-14 01:59′)
(204’PHL”ATL”2017-10-01 19:18”2017-10-01 22:17′)
(91’JFK”PIT”2017-01-15 04:25”2017-01-15 04:56′)
(225’SFO”IAH”2017-03-30 16:38”2017-03-30 18:51′)
(184’LAS”BOI”2017-02-13 06:31”2017-02-13 08:20′)
(33’JAX”ORD”2017-01-03 10:32”2017-01-03 13:20′)
(225’DFW”JFK”2017-06-08 10:32”2017-06-08 13:46′)
(61’LAX”PHL”2017-03-13 21:42”2017-03-14 02:54′)
(164’DFW”LAX”2017-03-09 03:37”2017-03-09 10:29′)
(31’IAH”MIA”2017-02-15 18:41”2017-02-15 23:48′)
(273’LAX”SLC”2017-03-18 05:35”2017-03-18 08:32′)
(192’LAX”DFW”2017-01-10 14:20”2017-01-10 16:07′)
(214’JFK”PHL”2017-12-21 21:36”2017-12-21 22:35′)
(25’IAH”MIA”2017-01-10 00:56”2017-01-10 01:03′)
(154’SFO”PHL”2017-02-11 08:55”2017-02-11 10:40′)
(144’ORD”JAX”2017-12-11 06:23”2017-12-11 06:49′)
(61’MIA”DFW”2017-01-22 08:42”2017-01-22 13:30′)
(13’MCO”LAX”2017-03-24 09:54”2017-03-24 16:04′)
(131’LAS”PHL”2017-01-01 00:36”2017-01-01 05:32′)
(92’SFO”ORD”2017-02-02 01:33”2017-02-02 04:40′)
(255’MIA”ORD”2017-02-08 01:23”2017-02-08 03:38′)
(245’IAH”PIT”2017-02-22 19:34”2017-02-22 22:27′)
(222’LAX”ORD”2017-01-23 19:26”2017-01-24 00:37′)
(115’ATL”ORD”2017-07-12 17:23”2017-07-12 19:30′)
(262’JFK”MCO”2017-12-09 00:23”2017-12-09 03:27′)
(121’MCO”SEA”2017-07-03 10:18”2017-07-03 10:57′)
(92’SEA”LAX”2017-03-21 09:42”2017-03-21 10:59′)
(273’LAX”ORD”2017-01-03 23:16”2017-01-04 04:10′)
(245’BOI”ORD”2017-03-06 18:28”2017-03-06 21:13′)
(75’SEA”MCO”2017-01-03 00:25”2017-01-03 04:09′)
(163’BOI”PHL”2017-01-09 11:07”2017-01-09 13:20′)
(223’JAX”PIT”2017-01-04 04:36”2017-01-04 06:13′)
(73’IAH”JFK”2017-01-31 09:26”2017-01-31 10:20′)
(104’LAX”IAH”2017-01-11 11:08”2017-01-11 12:58′)
(32’LAS”LAX”2017-01-19 14:08”2017-01-19 16:29′)
(261’SEA”DFW”2017-12-24 07:34”2017-12-24 11:23′)
(245’LAX”MCO”2017-12-28 20:55”2017-01-01 02:05′)
(175’ORD”JAX”2017-12-24 18:42”2017-12-24 19:41′)
(112’JFK”MIA”2017-03-17 08:07”2017-03-17 08:38′)
(201’ATL”PIT”2017-01-25 09:46”2017-01-25 10:51′)
(112’MIA”LAX”2017-05-16 01:02”2017-05-16 02:47′)
(165’SFO”JFK”2017-01-12 09:38”2017-01-12 10:58′)
(61’DFW”JFK”2017-01-10 17:24”2017-01-10 18:31′)
(13’SEA”PIT”2017-11-08 08:57”2017-11-08 13:09′)
(14’LAX”ORD”2017-12-14 10:43”2017-12-14 12:00′)
(153’JAX”SLC”2017-03-28 18:04”2017-03-28 22:56′)
(211’SFO”ATL”2017-05-30 15:57”2017-05-30 19:37′)
(91’PHL”JAX”2017-02-28 09:36”2017-02-28 14:02′)
(62’IAH”MCO”2017-07-13 20:39”2017-07-14 01:28′)
(35’DFW”JFK”2017-03-22 08:28”2017-03-22 10:10′)
(174’JAX”LAS”2017-01-08 08:20”2017-01-08 09:04′)
(24’LAS”MCO”2017-03-29 12:30”2017-03-29 18:13′)
(271’ATL”DFW”2017-02-27 06:04”2017-02-27 09:04′)
(245’PHL”DFW”2017-01-10 20:21”2017-01-10 21:08′)
(212’IAH”LAX”2017-02-16 13:31”2017-02-16 16:09′)
(65’ORD”MIA”2017-01-21 05:47”2017-01-21 10:08′)
(242’IAH”SLC”2017-01-20 11:04”2017-01-20 18:51′)
(264’LAX”SLC”2017-12-13 20:35”2017-12-14 02:03′)
(272’PIT”PHL”2017-12-17 09:02”2017-12-17 09:07′)
(181’SLC”DFW”2017-01-29 17:45”2017-01-29 23:46′)
(245’PIT”MCO”2017-01-18 02:59”2017-01-18 07:47′)
(42’JAX”JFK”2017-03-25 17:16”2017-03-25 20:54′)
(174’SLC”SEA”2017-01-15 13:08”2017-01-15 13:43′)
(203’SFO”DFW”2017-02-28 02:22”2017-02-28 05:56′)
(82’DFW”IAH”2017-03-08 11:30”2017-03-08 11:34′)
(95’SEA”IAH”2017-02-23 13:55”2017-02-23 16:44′)
(165’ORD”ATL”2017-03-14 11:49”2017-03-14 15:23′)
(93’ORD”SFO”2017-03-30 11:20”2017-03-30 16:23′)
(234’JAX”MCO”2017-03-14 17:59”2017-03-14 18:09′)
(242’ATL”PHL”2017-01-02 12:42”2017-01-02 16:47′)
(44’JFK”DFW”2017-03-28 14:05”2017-03-28 20:03′)
(11’SEA”ORD”2017-02-18 05:51”2017-02-18 08:35′)
(102’MCO”JFK”2017-07-06 19:11”2017-07-06 22:35′)
(93’LAX”ORD”2017-01-03 09:55”2017-01-03 12:03′)
(165’JAX”BOI”2017-03-24 06:34”2017-03-24 07:36′)
(84’PHL”IAH”2017-01-06 01:49”2017-01-06 05:34′)
(194’LAX”IAH”2017-02-15 04:44”2017-02-15 05:37′)
(255’MCO”SEA”2017-01-12 15:26”2017-01-12 16:45′)
(175’LAS”MIA”2017-03-26 21:53”2017-03-26 22:20′)
(21’PIT”LAX”2017-12-18 10:15”2017-12-18 13:15′)
(253’PHL”SFO”2017-03-01 10:38”2017-03-01 12:15′)
(171’DFW”PIT”2017-01-11 15:40”2017-01-11 19:04′)
(165’SEA”MIA”2017-03-26 15:44”2017-03-26 22:43′)
(162’ATL”IAH”2017-01-28 14:58”2017-01-28 15:56′)
(103’PHL”SLC”2017-02-20 10:57”2017-02-20 11:57′)
(253’SEA”LAS”2017-02-02 17:47”2017-02-02 19:47′)
(62’MCO”MIA”2017-07-02 01:16”2017-07-02 04:27′)
(22’SLC”IAH”2017-07-09 19:42”2017-07-09 20:34′)
(251’MCO”JFK”2017-07-08 08:26”2017-07-08 11:57′)
(43’MCO”LAX”2017-01-06 02:39”2017-01-06 04:39′)
(14’ATL”PIT”2017-03-14 13:44”2017-03-14 18:07′)
(152’ORD”PHL”2017-12-13 08:17”2017-12-13 08:47′)
(224’ATL”JFK”2017-02-20 18:05”2017-02-20 22:41′)
(203’LAS”PIT”2017-07-09 02:39”2017-07-09 04:39′)
(182’SLC”DFW”2017-03-20 10:31”2017-03-20 11:49′)
(43’JAX”ORD”2017-12-14 02:42”2017-12-14 05:43′)
(241’PHL”BOI”2017-02-14 06:52”2017-02-14 08:29′)
(13’PIT”JAX”2017-07-03 07:55”2017-07-03 09:43′)
(85’PIT”JFK”2017-01-06 06:28”2017-01-06 07:11′)
(11’SLC”PHL”2017-01-21 01:58”2017-01-21 08:51′)
(244’IAH”MCO”2017-07-04 02:12”2017-07-04 02:28′)
(204’JAX”JFK”2017-01-15 05:19”2017-01-15 06:20′)
(61’MCO”PIT”2017-12-09 05:10”2017-12-09 05:12′)
(172’ATL”PHL”2017-02-09 20:04”2017-02-09 23:59′)
(241’MIA”BOI”2017-03-04 06:30”2017-03-04 08:45′)
(102’LAS”JFK”2017-12-21 02:56”2017-12-21 03:47′)
(154’JAX”JFK”2017-07-04 05:36”2017-07-04 10:27’);
/* Remove Carrier_ID from Flights table for circular reference removal */
Alter Table Flights drop column Carrier_ID;
— Append Update section to populate number of seats column in aircraft table
Update airlines.aircraft set number_of_seats=500 where plane_id in (135711);
Update airlines.aircraft set number_of_seats=100 where plane_id in (12131415);
Update airlines.aircraft set number_of_seats=250 where plane_id in (246810);
Update airlines.aircraft set number_of_seats=550 where plane_id in (16182022);
Update airlines.aircraft set number_of_seats=300 where plane_id in (17192123);
Update airlines.aircraft set number_of_seats=400 where plane_id in (24252627);
commit;
Posted in Uncategorized