Nayyar Iqbal

Work place: Department of Computer Science of Agricultural University, Faisalabad, Pakistan

E-mail: nayyar_ciit@yahoo.com

Website:

Research Interests: Software Construction, Software Engineering, Computer systems and computational processes, Systems Architecture

Biography

Nayyar Iqbal: Lecturer at computer science Department at Agricultural University of Faisalabad, Pakistan major database systems and software engineering.

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

By M. Rizwan Jameel Qureshi Mahaboob Sharief Shaik Nayyar Iqbal

DOI: https://doi.org/10.5815/ijitcs.2012.02.07, Pub. Date: 8 Mar. 2012

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.

[...] Read more.
Other Articles