1. 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. (Hint: Look at the data values to determine the nature of the
relationships. For example, note that employee Melton has flown two charter trips as pilot and one trip as
copilot.)
2. Decompose the dependency diagram you drew to solve part 1 (Problem 11 in the text) to create table
structures that are in 3NF and write the relational schema.
3. Draw the Crow’s Foot ERD to reflect the properly decomposed dependency diagrams you created in the
second part of this problem. Make sure the ERD yields a database that can track all of the data shown above.
Show all entities, relationships, connectivities, optionalities, and cardinalities.
Part 2: Write a summary paragraph outlining the importance of normalization to large databases such as
HCUP or HEDIS.