QUESTION 1 Table 1 contains invoice data for the PV Furniture Company. Questions (a) -(e) refer to the table. Table 1: Invoice Data PV Furniture Company CustID CName Value Furniture CAddr Plano, TX ProdID 7 OrdQty 2 5 2 ProdDesc ProdFin UnitPrice Dine Table Natural Ash 800 Writer Desk Cherry Ent'mt Ctr 325 Natural Maple 650 4Dr Dresser Oak 500 Ent'mt Ctr Natural 650 Maple 4 11 6 Furniture Gallery Bouler, CO 4 (a) Table 2 is not in First Normal Form (1NF). Why? Transform Table 2 into a INF table. (b) List all functional dependencies from the 1NF table produced in Question 2(a). (c) Write the INF relation schema for the 1NF table produced in Question 2(b). Identify the Primary key for the INF relation. (d) Is the relation produced in Question 2(c) is in Second Normal Forma (2NF)? Justify your answer. If the relation is not in 2NF, transform the relation into 2NF relation(s). (e) Is/Are the relation(s) produced in Question 2(d) in Third Normal Form (3NF)? Justify your answer. For every relation not in 3NF, convert the relation into 3NF relation(s)