Academic Journals Database
Disseminating quality controlled scientific knowledge

Using Fuzzy Logic to Evaluate Normalization Completeness for an Improved Database Design

ADD TO MY LIST
 
Author(s): M. Rizwan Jameel Qureshi | Mahaboob Sharief Shaik | Nayyar Iqbal

Journal: International Journal of Information Technology and Computer Science
ISSN 2074-9007

Volume: 4;
Issue: 2;
Start page: 48;
Date: 2012;
Original page

Keywords: Normalization completeness | Conceptual model | Relation | Functional dependency | Total attributes | Completeness attributes | Preventing attributes

ABSTRACT
A new approach, to measure normalization completeness for conceptual model, is introduced using quantitative fuzzy functionality in this paper. We measure the normalization completeness of the conceptual model in two steps. In the first step, different normalization techniques are analyzed up to Boyce Codd Normal Form (BCNF) to find the current normal form of the relation. In the second step, fuzzy membership values are used to scale the normal form between 0 and 1. Case studies to explain schema transformation rules and measurements. Normalization completeness is measured by considering completeness attributes, preventing attributes of the functional dependencies and total number of attributes such as if the functional dependency is non-preventing then the attributes of that functional dependency are completeness attributes. The attributes of functional dependency which prevent to go to the next normal form are called preventing attributes.
Affiliate Program      Why do you need a reservation system?