Question: Draw the determinancy diagram : Task: Consider the ORDER table below and assume Order ID, Customer ID, Product ID, Depot ID are unique identifiers. Determinacy
Draw the determinancy diagram :

Task: Consider the ORDER table below and assume Order ID, Customer ID, Product ID, Depot ID are unique identifiers. Determinacy Diagram. Draw the DETERMINANCY DIAGRAM for the data below. State any assumption that you make. Customer Order ID Product ID Customer Name Depot ID Depot Location Unit Price Quantity ID 001 P116 C001 DP 1 Hendon 599 1 001 PO58 C001 DP1 Hendon 29 2 002 P231 C002 DP2 Dover 449 1 John Perry John Perry Andy King Andy King Peter Elton 002 PO58 C002 DP2 Dover 29 3 003 P231 C003 DP1 Hendon 449 1 004 PO79 C004 DP3 Reading 89 Simon Nash 2 004 P231 C004 DP3 Reading 449 Simon Nash 1
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
