Repetition of Information
Next: Boyce-Codd Normal Form
Up: Desirable Properties of
Previous: Dependency Preservation
-
Our decomposition does not suffer from the repetition of information problem.
- Branch and loan data are separated into distinct relations.
- Thus we do not have to repeat branch data for each loan.
- If a single loan is made to several customers, we do not have
to repeat the loan amount for each customer.
- This lack of redundancy is obviously desirable.
- We will see how this may be achieved through the use of
normal forms.
Page created and maintained by Osmar R. Zaï ane
Last Update:
Mon Oct 16 17:18:28 PDT 1995