Given the sample records in the CHARTER table shown in Table P6.11, do the following:

a. Write the relational schema and draw the dependency diagram for the table structure. Make sure that you label all dependencies. CHAR_PAX indicates the number of passengers carried. The CHAR_MILES entry is based on round-trip miles, including pickup points.
b. Decompose the dependency diagram in Problem 11a to create table structures that are all in 3NF and write the relational schema. Make sure that you label all dependencies.
c. Draw the Crow's Foot ERD to reflect the properly decomposed dependency diagrams you created in Problem 11b. Make sure that the ERD yields a database that can track all of the data shown in Problem 11. Show all entities, relationships, connectivities, optionalities, and cardinalities.

Transcribed Image Text:

Attribute Name CHAR TRIP CHAR DATE CHAR CITY CHAR MILES CUST NUM CUST LNAME CHAR PAX CHAR CARGO PILOT COPILOT FLT_ENGINEER LOAD MASTER AC NUMBER MODEL CODE MODEL SEATS MODEL CHG MILE$2.79 Sample Value Sample Value Sample Value Sample Value 10235 10232 15-Jan-201415-Jan-201416-Jan-2014 17-Jan-2014 STL 580 784 Brown 5 235 lbs Melton 10233 10234 MIA 1,290 231 Hanson 12 18,940 1bs Chen Henderson O'Shaski Benkasi 3456Y CV-580 38 $23.36 TYS 524 544 Bryana ATL 768 784 Brown 348 lbs Henderson Melton Melton 155 lbs 1234Q PA31-350 10 1234Q PA31-350 PA31-350 10 $2.79 2256W 10 $2.79