Question 2 (35 Marks) Apply the normalization rules to the following Form, which show the data to be recorded in a database. All intermediate steps (UNF, INF, 2NF, and 3NF) should be shown in detail. State any assumptions that you make. Order Form Order number: 1234 Date: 11/04/98 Customer number: 9876 Customer name: Billy Customer address: 456 HighTower Street City-Country: Hong Kong, China Product No Desscription Quantity Unit Price A123 Pencil 100 $3.00 B234 Eraser 200 $1.50 C345 Sharpener 5 $8.00 Please complete the following FOUR (4) parts: i) Based on Figure 2, write down the unnormalized form. (5 marks) ii) Identify the repeating group of attributes and transform part (i) into tables that are in 1st Normal form. (Explain the rationale for your decision). (10 marks) iii) Identify any partial dependencies in part (ii) and transform into tables that are in 2nd Normal Form. (Explain the rationale for your decision). (10 marks) iv) Identify any transitive dependencies in part (iii) and transform into tables that are in 3rd Normal Form. (Explain the rationale for your decision). (10 marks)