Question 3 Normalize table 1 to a set of Third Normal Form (3NF) relations. Your answer should show all the three stages of normalization (1NF, 2NF and 3NF) by using the Database Design Language...

Extracted text: Question 3 Normalize table 1 to a set of Third Normal Form (3NF) relations. Your answer should show all the three stages of normalization (1NF, 2NF and 3NF) by using the Database Design Language format (underline all primary keys, composite keys and use an * to indicate the foreign keys). State the component(s) that is/are removed from each Normal Form. Besides that, INF must be divided into repeating and non-repeating group relations. a) PatientID PatientName BloodID BloodType ExamDate DiseaselD DiseaseDesc HospitallD HospitalName 08/01/2020 D5001 08/01/2020 D3222 |11/11/2020 D5001 |11/11/2020 D7788 15/11/2020 D5001 12/12/2020 D3222 12/12/2020 D5001 Alice Hospital KL Hospital KL Hospital PJ Hospital SB Hospital SB Hospital KL Hospital PJ P7010 B001 B001 B001 A+ COVID-19 Н223 P7010 Alice A+ Diabetes H223 Alice Thomas P7010 A+ COVID-19 H881 P8888 B008 O- SARS H666 Penny Penny Julie P3000 B009 AB+ COVID-19 H666 P3000 B009 AB+ Diabetes H223 P4455 B008 0- COVID-19 H881 Table 1: Details of PatientDiseaseExam Table