(Answered): 1- Given the dependency diagram illustrated in Figure 1 answer the following questions. C1 C2 C3 C4 ...

1- Given the dependency diagram illustrated in Figure 1 answer the following questions. C1 C2 C3 C4 C5 Figure 1 - Depency Diagram a) Identify all indicated dependencies and discuss their dependency type. b) Normalize the database to at 2NF level. Show the dependency diagram for each table in 2NF. c) Normalize the database to 3NF level. Show the dependency diagram for each table in 3NF.