Fuzzy normal forms and a dependency-preserving decomposition into &thetas;-F3NF

Author

Chen, Guoqing ; Kerre, Etienne E. ; Vandenbulcke, Jacques

Author_Institution

Dept. of Appl. Econ. Sci., Katholieke Univ., Leuven, Belgium

fYear

1994

fDate

26-29 Jun 1994

Firstpage

156

Abstract

In a fuzzy data model where imprecision of both attribute values and relationships among domain elements is taken into account, problems of data redundancy and update anomalies which are similar to those in classical databases are still found to exist. To cope with these problems, a number of fuzzy normal forms have been defined, based on fuzzy functional dependency, to serve as theoretical guidelines for fuzzy relational database design. This results in the notions of θ-keys, fuzzy first normal form (F1NF), θ-fuzzy second normal form (θ-F2NF), θ-fuzzy third normal form (θ-F3NF), and θ-fuzzy Boyce-Codd normal form (θ-FBCNF). Furthermore, the scheme decomposition into θ-F3NF is discussed in the light of the dependency-preserving property

Keywords

database theory; fuzzy systems; relational algebra; relational databases; &thetas;-fuzzy Boyce-Codd normal form; &thetas;-fuzzy second normal form; &thetas;-fuzzy third normal form; &thetas;-keys; attribute value imprecision; data redundancy; dependency-preserving decomposition; domain element relationships; fuzzy data model; fuzzy first normal form; fuzzy functional dependency; fuzzy relational database design; normalization theory; update anomalies; Artificial intelligence; Buildings; Computer science; Data models; Guidelines; Informatics; Mathematics; Relational databases;

fLanguage

English

Publisher

ieee

Conference_Titel

Fuzzy Systems, 1994. IEEE World Congress on Computational Intelligence., Proceedings of the Third IEEE Conference on

Conference_Location

Orlando, FL

Print_ISBN

0-7803-1896-X

Type

conf

DOI

10.1109/FUZZY.1994.343700

Filename

343700