Please answer all the following questions to receive a thumbs up.

Chapter 6 Normalization of Database Tables 1. The following shows the dependency diagram for an unnormalized data. Identify each of the dependencies below and say why you chose your response (fill in the blanks): a1 C2 C3 C4 C5 i. ii. C1 C4 C2: represents a C5: represents a dependency, because dependency, because 2. The following shows the database and dependency diagrams where the tables are at least in 2NF. Table1 Table2 Do the following: i. Identify the primary key for Tablel and Table2. ii. Identify the foreign key for Tablel and Table2. 3. The following shows the database and dependency diagrams where the tables are at least in 3NF. Explain why this diagram is in 3NF. Table 1 Table2 Table3