Data Management

RDBNorma: - A Semi-Automated Tool for Relational Database Schema Normalization Up to Third Normal Form

Date Added: Feb 2011
Format: PDF

In this paper a tool called RDBNorma is proposed, that uses a novel approach to represent a relational database schema and its functional dependencies in computer memory using only one linked list and used for semi-automating the process of relational database schema normalization up to third normal form. This paper addresses all the issues of representing a relational schema along with its functional dependencies using one linked list along with the algorithms to convert a relation into second and third normal form by using above representation. The authors have compared performance of RDBNorma with existing tool called Micro using standard relational schemas collected from various resources.