WSEAS Transactions on Mathematics
Print ISSN: 1109-2769, E-ISSN: 2224-2880
Volume 19, 2020
A Method for Normalization of Relation Schema Based on Data to Abide by the Third Normal Form
Author:
Abstract: Data bases play an important role in applied Mathematics. Normalization for relational databases is very important to avoid anomalies of relations which may not be in normalized forms of the third normal forms. But, normalization may be a difficult task, since the designers of the databases may not fully understand the domain of each attribute that are contained in the relation schema or they may not have full understanding about the concept of normalization. In this paper an efficient method that checks the possibility of the need of further normalization using stored data in relations is presented based on possible functional dependencies between attributes in the relations. By checking possible functional dependencies, the database designers can determine the need of further normalization, and may improve the structure of the relation schemas. Experiments were performed for an example of relational database that can be found in the organization of tutorial of MySQL which is a representational database management system, and the experiments showed good results.
Search Articles
Keywords: Applied Mathematics, Algorithms, Information Theory, Normalization, Relational Databases, Normal forms, Functional dependency, Database system
Pages: 216-225
DOI: 10.37394/23206.2020.19.20