Enclosed are few Charter records. Create and submit DB design based on the sample data. AC number is aircraft number. Data shows that we have two aircraft model types and few aircraft of each type. Each charter_trip (or rental) involves customer, aircraft, and employees (Hint: you can make a associative (bridge) entity to link employees and charter_trips.

ATTRIBUTE NAME SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPIE VALUE 10232 10233 10234 10235 CHAR_TRIP CHAR_DATE CHAR_CITY 15-Jan-2004 15-Jan-2004 16-Jan-2004 17-Jan-2004 STL MIA TYS ATL CHAR MILES 580 1,290 524 768 CUST_NUM 784 231 544 784 CUST LNAME Brown Hanson Bryana Brown CHAR PAX 5 2 5 CHAR CARGO 235 lbs. 18,940 lbs. 348 lbs. 155 lbs. PILOT Melton Chen Henderson Melton COPILOT Henderson Melton FLT ENGINEER O'Shaski LOAD MASTER Benkasi AC NUMBER 12340 2256 1234Q PA31-350 MODEL_CODE PA31-350 CV-580 PA31-350 MODEL SEATS 10 38 MODEL_CHO_MILE $2.79 22. Decompose the dependency diagram in Problem 21 to create table structures thal are all in 3NE Make