Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Normalize the table in the image to 3NF Functional Dependencies: Dept#, Cust# -> DeptName, Location, MgrID, MgrName, CustName, ComDate, Complaint Dept# -> DeptName, Location,MgrID MgrID
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 IUStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started