Data Management

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

Date Added: Mar 2012
Format: PDF

A new approach, to measure normalization completeness for conceptual model, is introduced using quantitative fuzzy functionality in this paper. The authors 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.