Desirable Properties of Decomposition

1. We'll take another look at the scheme

   

   which we saw was a bad design.

2. The set of functional dependencies we required to hold on this scheme was:

   

3. If we decompose it into

   

   we claim this decomposition has several desirable properties.

• Lossless-Join Decomposition
• Dependency Preservation
• Repetition of Information