Assignment 6: Determinacy Diagrams for MIS208 Data Analysis

Assignment 6: Determinacy Diagrams 
Set: 25 April 2014 Due: 2 May 2014
 p.62-63
Q.1. For each of the following determinancy diagrams, identify each determinant and the attribute(s) it directly determines. Omit any transitive dependencies. Questions a, c, e, h, j, o, q

ANSWERS 

orderNo and itemNo are determinants for above figure(a) and orderDate and quantity are attributes determine.

orderNo and customerNo are determinants for above figure(c) and customerNo and adress are attributes determine.

branchNo and customerSerialNo are determinants for above figure(e) and creditLimit and adress are attributes determine.

A is determinant for above figure(h) B and C are attributes determine.

J, K and L are determinants for above figure(j) L,M and N are attributes determine.

H, J and K are determinants and attributes determine for above figure(o).

P,Q and R are determinants for above figure(q) P and R are attributes determine.