Normalization Using Multivalued Dependencies

1. Suppose that in our banking example, we had an alternative design including the scheme:

   

   We can see this is not BCNF, as the functional dependency

   

   holds on this scheme, and cname is not a superkey.

2. If we have customers who have several addresses, though, then we no longer wish to enforce this functional dependency, and the scheme is in BCNF.

3. However, we now have the repetition of information problem. For each address, we must repeat the loan numbers for a customer, and vice versa.

• Multivalued Dependencies
• Theory of Multivalued Dependencies
• Fourth Normal Form (4NF)