solution with primary keys and foreign keys

Task 2: Consider the scenario given below to answer the following questions. (Total: 50 marks) 1-Considering your answer for Task 2a, normalize the solution to convert it into 2 nd Normal Form (2 NF). Also identify the primary keys and the foreign keys. 2- Normalize the solution of 2NF to 3NF by identifying the transitive dependency for the solution of Task 2 b. Also identify the primary keys and the foreign keys