On the menbership problem for functional and multivalued dependencies in relational databases

Catriel Beeri*

*Corresponding author for this work

Research output: Contribution to journalArticlepeer-review

122 Scopus citations

Abstract

The problem of whether a given dependency in a database relation can be derived from a given set of dependencies is investigated. We show that the problem can be decided in polynomial time when the given set consists of either multivalued dependencies only or of both functional and multivalued dependencies and the given dependency is also either a functional or a multivalued dependency. These results hold when the derivations are restricted not to use the complementation rule.

Original languageEnglish
Pages (from-to)241-259
Number of pages19
JournalACM Transactions on Database Systems
Volume5
Issue number3
DOIs
StatePublished - 1 Sep 1980
Externally publishedYes

Keywords

  • functional dependency
  • inference rule
  • membership
  • multivalued dependency
  • relations

Fingerprint

Dive into the research topics of 'On the menbership problem for functional and multivalued dependencies in relational databases'. Together they form a unique fingerprint.

Cite this