Problem #$2$

Based on the following dependency diagram and relational scheme, accomplish the tasks.

The relational schema is written as follows:

CHARTER $($CHAR TRIP, CHAR$\_$DATE, CHAR$\_$CITY, CHAR$\_$MILES, CUST$\_$NUM,

CUST$\_$LNAME, CHAR$\_$PAX, CHAR$\_$CARGO, PILOT, COPILOT,

FLT$\_$ENGINEER, LOAD$\_$MASTER, AC$\_$NUMBER, MOD$\_$CODE,

MOD$\_$SEATS, MOD$\_$CHG$\_$MILE$)$

Task $01$ Please explain which normal form $(1$NF$,2$NF or $3$NF$)$ is it in and why.

Solution:

Task $02$ Write the relational schema that meet the requirements of $3NF,$ and ensure that you

indicate the FK in the tables.

Solution: