Mapping Fuzzy EER Model Concepts to Relations
Jose Galindo (Universidad de Málaga, Spain), Angelica Urrutia (Universidad Católica del Maule, Chile) and Mario Piattini (Universidad de Castilla-La Mancha, Spain)
Copyright: © 2006
This chapter shows the transformation of the FuzzyEER model to a logical design by using relational databases. The FuzzyEER-to-Relational mapping algorithm is based on the “classical” EER-to-Relational mapping algorithm, published in Elmasri and Navathe (2000) and summarized in the first section of this chapter, but other versions are very similar (De Miguel, Piattini, & Marcos, 1999; Silverschatz, Korth, & Sudarshan, 2002). The FuzzyEER-to-Relational mapping algorithm includes additional rules for mapping fuzzy concepts. The following sections translate the FuzzyEER concepts, that is, the definitions in Chapter IV, to the FIRST-2 schema, which was exposed in Chapter V. Thus, this chapter relates Chapter IV with Chapter V, obtaining a fuzzy relational database. In addition, we need a comprehensive fuzzy database language with statements for data definition, query, and update. This language is FSQL (Fuzzy SQL), and we describe it in Chapter VII.