Use the data provided below by your customer to demonstrate the process of normalization and derive the relational model for each of the first THREE normal forms.

First Normal Form:

Create the relational model showing the table in $1$NFDraw the dependency diagram

Second Normal Form:

Determine two partial dependenciesCreate the relational model showing all tables in $2$NF

Third Normal Form:

Identify two transitive dependenciesCreate the dependency diagram for$$ONLY the TWO$$tables$$that have been created$/$changed from $2$NF$.$Create the relational model showing all tables in $3$NF