1. Identify and discuss each of the dependencies indicated in above diagram.
   • C1 → C2 represents a partial dependency, because C2 depends only on C1, rather than on the entire primary key composed of C1 and C3.

   • C4 → C5 represents a transitive dependency, because C5 depends on an attribute (C4) that is not part of a primary key.

   • C1, C3 → C2, C4, C5 represents a functional dependency, because C2, C4, and C5 depends on the primary key composed of C1 and C3.

    

2. Create a database whose tables are at least in 2NF, showing the dependency diagrams for each table.

   

    

3. Create a database whose tables are at least in 3NF, showing the dependency diagrams for each table.