Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I would prefer 34. being answered 33. For the big order database table, list FDs with the column CustNo as the determinant that are not
I would prefer 34. being answered
33. For the big order database table, list FDs with the column CustNo as the determinant that are not true due to the sample data. For each FD, identify the sample rows that contradict it. Remember that it takes two rows to contradict an FD. The sample data are repeated in Table 7-P4 for your reference Table 7-P4: Sample Data for the Big Order Database Table OrdNo temNo atyOrd PlantNo CustNo CustBa CustDisc ReordPt OrdDate 01 01 02 02 03 10 P1 10 P1 5 P1 5 P1 10 P2 C1 C1 C2 C2 C1 0.10 0.10 0.05 0.05 0.10 10 1/15/2014 10 1/15/2014 20 1/16/2014 10 1/16/2014 10 1/17/2014 100 12 100 14 34. Following on problem 33, list FDs with the column CustNo as the determinant that the sample rows do not violate. Do not show violations for CustNo-CustBal, Cust Disc because these FDs are true. For each FD, add one or more sample rows and then identify the sample rows that contradict the FD. Remember that it takes two rows to contradict an FDStep 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