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 :
بازگشت