Change the given tables to 3NF. Show the answers in tables.

2. Change the given table in 3NF OID = Order ID, O Date=Order Date, CID = Customer ID, C_Name = Customer Name, C_State = Customer's State, PID = project id, P Desc =Project Name, P Price = Product Price, Qty = Quantity Purchased Note: 7,5,4 means three Product IDs. Similarly, 1, 1, 5 means three Quantities. Functional Dependencies are: OID -> Date CID ->C_Name OID -> CID CID -> C State PID -> P_Desc PID and OID -> Qty PID->P_Price OID 1006 O Date CID 10/24/09 2 C Name C State PID P Desc P Price Qty Apex NC 7,5,4 Table, 800, 1,1,5 Desk, 325. Chair 200 Acme GA 11,4 Dresser, 500, 4,6 Chair 200 1007 10/25/096 3. Change the given table in 3NF Regno Name DOB Phone Gender CID CName Ins_ID Ins_Name Ins_Office 14M01 Kumar 12-Jan-1996 12345 M C1 DBMS 11 Kesav G123 14M05 Mary 10-Jun-1995 12367 F C1 DBMS 11 Kesav G123 14M07 Ram 10-May-1996 12898 M C1 DBMS 12 Ragav G127 14M01 Kumar 12-Jan-1996 12345 M C3 DS 15 Mani G125 14B01 Revathi 10-Dec-1995 23456 F C3 DS 15 Mani G125 14M09 Steve 23-Oct-1995 34567 M C4 OS 15 Mani G125 14B03 Ramya 20-Jul-1996 23456 F C4 OS 15 Mani G125