Multivalued Dependency - Formal Definition

Formal Definition

The formal definition is given as follows.

Let be a relation schema and let and (subsets). The multivalued dependency

(which can be read as multidetermines ) holds on if, in any legal relation, for all pairs of tuples and in such that, there exist tuples and in such that





In more simple words the above condition can be expressed as follows: if we denote by the tuple having values for collectively equal to correspondingly, then whenever the tuples and exist in, the tuples and should also exist in .

Read more about this topic:  Multivalued Dependency

Famous quotes containing the words formal and/or definition:

    Two clergymen disputing whether ordination would be valid without the imposition of both hands, the more formal one said, “Do you think the Holy Dove could fly down with only one wing?”
    Horace Walpole (1717–1797)

    Scientific method is the way to truth, but it affords, even in
    principle, no unique definition of truth. Any so-called pragmatic
    definition of truth is doomed to failure equally.
    Willard Van Orman Quine (b. 1908)