You are here

Decomposition

19 January, 2016 - 14:28
media/image6.png
Figure 11.3
 

If X determines Y and Z, then X determines Y and X determines Z separately. This is the reverse of Union. If you have a table that appears to contain two entities that are determined by the same PK, consider breaking them up into two tables.