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) Fundamentals of Relational Database Management Systems (COMP 20002.1) - Fall - 22- CW2 (Assignment) - ALL - QP b) Considering your answer for Task 2a, normalize the solution to convert it into 2nd Normal Form (2 NF). Also identify the primary keys and the foreign keys. (12 marks) c) Normalize the solution of 2NF to 3 NF by identifying the transitive dependency for the solution of Task 2b. Also identify the primary keys and the foreign keys. (15 marks)