Question: 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,

 33. For the big order database table, list FDs with the

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 ItemNo QtyOrd 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 100 100 200 200 100 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 12 13 14

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!