Write the relational schema and draw the dependency

diagram. Make sure that you label the transitive and$/$or partial dependencies. Write the relational schemas and create a set of dependency diagrams that meet $2$NF

requirements. Create the set of tables for the generated relational schemas. Write the relational schemas and create a set of dependency diagrams that meet $3$NF

requirements. Create the set of tables for the generated relational schemas.