Multivalued Dependency - Interesting Properties

Interesting Properties

  • If, Then
  • If and, Then
  • If and, then

The following also involve functional dependencies:

  • If, then
  • If and, then

The above rules are sound and complete.

  • A decomposition of R into (X, Y) and (X, RY) is a lossless-join decomposition if and only if X Y holds in R.

Read more about this topic:  Multivalued Dependency

Famous quotes containing the words interesting and/or properties:

    It’s interesting to leave a place, interesting even to think about it. Leaving reminds us of what we can part with and what we can’t, then offers us something new to look forward to, to dream about.
    Richard Ford (b. 1944)

    The reason why men enter into society, is the preservation of their property; and the end why they choose and authorize a legislative, is, that there may be laws made, and rules set, as guards and fences to the properties of all the members of the society: to limit the power, and moderate the dominion, of every part and member of the society.
    John Locke (1632–1704)