1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Discuss in my forum

Multivalued Dependency

By

Definition: Multivalued dependencies occur when the presence of one or more rows in a table implies the presence of one or more other rows in that same table.

For more detail, read What is a Database Dependency?
Examples:
For example, imagine a car company that manufactures many models of car, but always makes both red and blue colors of each model. If you have a table that contains the model name, color and year of each car the company manufactures, there is a multivalued dependency in that table. If there is a row for a certain model name and year in blue, there must also be a similar row corresponding to the red version of that same car.
  1. About.com
  2. Technology
  3. Databases
  4. Design
  5. Multivalued Dependency - Database Definition

©2014 About.com. All rights reserved.