Q$2$: Decompose the dependency diagram in Problem $11$a to create table structures that are all in $3NF$ and write the relational schema. Make sure that you label all dependencies.

The normalized dependency diagram is shown in Figure $3\mathrm{.}3.($Note the addition of MOD$\_$CODE in the AIRCRAFT table to serve as the AIRCRAFT table's FK to MODEL.$)$

C $2022$ Post University, Waterbury, CT

ALL RIGHTS RESERVED

Figure $3\mathrm{.}3.$ The Normalized Dependency Diagram

CHARTER table

CUSTOMER table

AIRCRUFT table

MODEL, tabie