Create table AirlineID (
	AirlineID char(5) primary key not null,
	Airline_desc varchar(100) not null);
	
Create table AirPortID (
	AirportID char(5) primary key not null,
	Airport_desc varchar(100) not null);
	
Create table AirPortSeqID (
	AirportSID char(7) primary key not null,
	AirportS_desc varchar(100) not null);
	
Create table MarketCityID (
	CityID char(5) primary key not null,
	City_desc varchar(100) not null);
	
	
Create table FlightDelay (
	SeqNumber integer primary key not null,
	FlightDate date,
	UniqueCarrier char(2),
	AirLineID char(5),
	Carrier char(2),
	TailNum varchar(10),
	FlightNumber integer,
	OriginAirport char(5),
	OriginAirportSeq char(6),
	OriginCityMarketID char(5),
	Origin char(3),
	OriginCityNm varchar(75),
	OriginStateAbr char(2),
	OriginStateNm varchar(25),
	DestAirport char(5),
	DestAirportSeq char(6),
	DestCityMarketID char(5),
	Dest char(3),
	DestCityNM varchar(75),
	DestStateAbr char(2),
	DestStateNm varchar(25),
	DepartTime datetime,
	DepartDelay datetime,
	TaxiOutTime char(3),
	WheelsOff datetime,
	WheelsOn datetime,
	TaxiInTime char(3),
	AirTime char(4));
	
Create table AirportCodes (
	AP_Code char(3) primary key not null,
	AP_Desc varchar(100));