create table CHARTER(
	CHAR_TRIP INT NOT NULL,
	CHAR_DATE DATETIME,
	AC_NUMBER CHAR (5),
	CHAR_DESTINATION CHAR (3),
	CHAR_DISTANCE DECIMAL (6,2),
	CHAR_HOURS_FLOWN DECIMAL (3,2),
	CHAR_HOURS_WAIT DECIMAL (3,2),
	CHAR_FUEL_GALLONS DECIMAL (5,2),
	CHAR_OIL_QTS INT,
	CUS_CODE INT,
	PRIMARY KEY (CHAR_TRIP));

create table EARNEDRATING(
	EMP_NUM INT,
	RTG_CODE CHAR (5),
	EARNRTG_DATE DATETIME,
	PRIMARY KEY (EMP_NUM));