• DocumentCode
    2836921
  • Title

    A Key Point on the Equivalence between Functional Dependencies and Logic Algebra

  • Author

    Yi-Shun Zhang

  • Author_Institution
    Coll. of Comput. & Inf. Eng., ZheJiang GongShang Univ., Hangzhou, China
  • fYear
    2009
  • fDate
    19-20 Dec. 2009
  • Firstpage
    1
  • Lastpage
    4
  • Abstract
    An equivalence between logic algebra and functional dependencies shows that a functional dependency is implied by a set of functional dependencies if and only if its corresponding product term is implied by corresponding logic function. In this paper we shall state and proof a key point ignored for a long time, that is any prime implicate in a corresponding logic function of a set of functional dependencies correspond a simplest functional dependency whose left side has no redundant attributes. Based on the point many problems in theory of functional dependency, such as computing minimum covers, all candidate keys, and closure of any set of attributes can be solved effectively and uniformly. The conclusion can be extended to data dependencies include multivalued dependencies easily.
  • Keywords
    process algebra; relational databases; data dependency; functional dependency; logic algebra; multivalued dependency; relational database; Algebra; Educational institutions; Logic functions; Merging; Relational databases;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Information Engineering and Computer Science, 2009. ICIECS 2009. International Conference on
  • Conference_Location
    Wuhan
  • Print_ISBN
    978-1-4244-4994-1
  • Type

    conf

  • DOI
    10.1109/ICIECS.2009.5364491
  • Filename
    5364491