database

Task 2: Consider the scenario given below to answer the following questions. (Total: 50 marks) a) Considering the above scenario, list the column names under the repeating and the non-repeating groups. Also identify the primary keys and the foreign keys for both the groups. ( 8 marks) MEC_AMO_TEM_035_04 Page 2 of Fundamentals of Relational Database Management Systems (COMP 20002.1) - Fall - 22- CWZ (Assignment) - Alt - QP b) Considering your answer for Task 2a, normalize the solution to convert it into 2 .1 Normal form (2) NF). Also identify the primary keys and the foreign keys. (12 marks) c) Normalize the solution of ZNF to 3NF by identifying the transitive dependency for the solution of Task 2b. Also identify the primary keys and the foreign keys. (15 marks)