FDs F- (CusNum CusName; PartNum PartDes; OrderNum OrderDate; (PartNum, OrderNum)
ID: 3709401 • Letter: F
Question
FDs F- (CusNum CusName; PartNum PartDes; OrderNum OrderDate; (PartNum, OrderNum) QtyOrder; (PartNum, OrderNum) Price) CusNum RepNum; PartNum Warchsc; OrderNum CusNum; OrderInfo Cus Cus Num Name Order Order Part Part Price Warehse Rep Qty Order Num Des Al's Appliance 21608 10/20/2007 AT94 Iron Num Date Num 148 148 Al's Appliance 2161910/23/2007 DR93 Gas Range 282 S21.95 20 and Sport $495.00 2 20 and Sport Brookings 21614 10/21/2007 KTO3 Dishwasher 2 $595.00 3s Direct 356 Fergusons 356 Ferguson's 2161010/20/2007 DR93 Gas Range 21610 10/20/2007 DW11 Washer 495.00 2 65 $399.99 $329.95 3 65 35 408 The Everything 21613 10/21/2007 K162 Dryer Shop 608Johnson's 21617 10/23/2007 BVo6 Home Gym 2 $794.95 2 Department Store 6o8 Johnson's 21617 10/2/2007 CDS2 Microwave4 s150.00 65 Oven Department Store 608 Johnson' 21623 10/23/2007 KV29 Treadmil 81,290.00 65 Figure 1. Functional dependencies F with sample OrderInfo relation
Explanation / Answer
17. b) A given order can be associated with only one representative (i.e. RepNum)
18. d) All of the above
19. b) {OrderNum, OrderDate, CusNum, CusName, RepNum}
20. b) {PartNum, OrderNum, RepNum}
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.