Normalize the table in the image to 3NF Functional Dependencies: Dept#, Cust# -> DeptName, Location, MgrID, MgrName, CustName, ComDate, Complaint Dept# -> DeptName, Location,MgrID MgrID -> MgrName Cust# -> CustName

Question 35 (12 points) Normalize this Table into 3NF DeptName Location MgrName CustName ComDate lComplaint 11232 Soap DivisionCincinnati Mary Samuel S11 11232 11314 Sundries 11623 Candle Division Atlanta Bill Tuner C97 P10451 Robert Drumtree 1/12/1998 Poor Service P10480 Steven Parks 1/14/1998 Discourteous Attendant P10784 John Smith P10113 DivisionCincinnati Samuel S11 New York Joe Brown G12 1/12/1998 Incorrect Price Greene 1/13/1998 Poor Service YOU DO NOT NEED TO COPY THE DATA. Just identify the tables. Normalize the table in the image to 3NF Functional Dependencies: Dept, Cust#-> DeptName, Location, MgriD, MgrName, CustName, ComDate, Complaint Dept#-> DeptName, Location,MgnD MgrlD-> MgrName Cust#-> Cust Name Paragraph B IU