i have all answers except question D

Task 2: Consider the scenario given below to answer the following questions. (Total: 50 marks) PHARMACY INFORMATION SYSTEM, APOLLO HOSPITALS Patient Prescription Bill Bill number: 0000501 Bill date: 02-December-2021 Patient Registration Number: 0500010001 Patient ID: 123456 Patient Name: Mohsin Patient Address: Al Khuwair Patient Category: M Doctor ID: 129 Doctor Name: Imaan 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) AMO_TEM_035_04 Page 2 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 3NF by identifying the transitive dependency for the solution of Task 2b. Also identify the primary keys and the foreign keys. (15 marks) d) Describe the steps taken with rules followed in each normal form that results in reducing the redundancy of data by dividing the large table into smaller tables. Use at least 1 e-book available through MEC e-library resource and provide appropriate citation and referencing using APA Referencing Style