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
Link To Document