QUESTION 2 Sun Mart sells a variety of products. The manager keeps a record on its customers' purchases as follows: Table 2: Customer Ordering by Sun Mart LastName OrderID Baba 1, 3, 5 Irfan 6 Lim 7 Maniam B Leo State Zip JH 81300 Table 3: Customer Profile by Sun Mart Cust ID FirstName LastName Address City 123, Jalan 1 Ali Baba Kebudayaan Skudai 231, Jalan 2 Ahmad Irfan Kebangsaan Skudai 3 Sandy Leo 11, Jalan Tampoi Tampoi 4 Maria Lim 11, Jalan Tampoi Tampoi 5 Subra Maniam 13, Jalan Tampoi Tampoi JH JH 81300 81200 81200 81200 JH JH Order ID 1 GTotal 135 90 5 2 ProdID AB-111 ZA-245 AB-111 AB-111 ZA-245 MB-153 ZA-245 ZA-245 Table 4: Customer Billing by Sun Mart Price Quantity Total Membership (10%Discount) 15 10 150 5 20 100 Yes 15 10 150 Yes 15 20 300 NO 20 100 No 10 10 100 Yes 5 10 50 Yes 5 10 50 NO 135 300 100 90 6 7 un 45 B 50 You are required to: a) Transform Table 2, 3, and 4 into its First Normalisation Form and show all possible dependencies, PK and FK. b) Normalise the tables in (a) into Second Normalisation Form c) Normalise the tables in (b) into its Third Normalisation Form