Mapping Fuzzy EER Model Concepts to Relations

Abstract

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.