Question

Problem 2 is worth 60% of the assignment grade. Convert the data shown below into a dependency diagram. Order_Details Orderid ProductID UnitPrice Quantity Sales Rep Total 10248 11 14.00 9.80 12 10 98.00 174.00 10249 5 10250 34.80 59 168.00 10251 18.60 91 10252 42.40 167.40 1,696.00 214.20 10253 40 12 10 10 35 8 7.70 10254 42.40 77.00 10255 16.80 1,261.40 10256 16.80 336.00 10257 15.60 95.76 10258 16.80 222.30 10259 64.80 2,462.40 10260 2.00 47.50 10261 27.20 40 4 1,088.00 10262 10.00 640.00 10263 604.80 14.40 16.00 20 6 42 5 40 6 15 11 10264 200.00 10265 3.60 342.72 10266 19.20 168.00

Answer 1

if you have any doubts please comment !!!!

note:- The tool used to draw dependency diagram is DIA

Dependency Diagram for the Data ORDER_DETAILS:-

ProductID Unit Price OrderID Quantity Sales Rep Total