An Ameliorated Approach towards Automating the Relational Database Normalization Process
P.B.Alappanavar1, Dhiraj Patil2, Radhika Grover3, Srishti Hunjan4, Yuvraj Girnar5
1P.B. Alappanavar, Assistant Professor, Department of IT, STES’s Sinhgad Academy of Engineering Pune, Maharashtra, India.
2Dhiraj Patil, Department of IT, STES’s Sinhgad Academy of Engineering Pune, Maharashtra, India.
3Radhika Grover, Department of IT, STES’s Sinhgad Academy of Engineering Pune, Maharashtra, India.
4Srishti Hunjan, Department of IT, STES’s Sinhgad Academy of Engineering Pune, Maharashtra, India.
5Yuvraj Girnar, Department of IT, STES’s Sinhgad Academy of Engineering Pune, Maharashtra, India.
Manuscript received on March 24, 2013. | Revised Manuscript received on April 12, 2013. | Manuscript published on April 30, 2013. | PP: 403-412 | Volume-2, Issue-4, April 2013. | Retrieval Number: D1463042413/2013©BEIESP
Open Access | Ethics and Policies | Cite
© The Authors. Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open access article under the CC BY-NC-ND license (http://creativecommons.org/licenses/by-nc-nd/4.0/)
Abstract: In the field of database systems in general and relational systems in particular, database design problem is of utmost importance as it helps to decide on a suitable logical structure for a given data to be represented in a database and concentrates on the fact that which relations are needed and what their attributes should be. Designing a database is a complex task and the normalization theory is a useful aid in the design process. In this paper, a tool is presented which aims to handle the normalization process up to third normal form(3NF) and even imparts the normalized relations to its users in different formats. The objective of the system is to provide an effective and efficient e-Learning system to individuals to learn normalization in an easy and quick manner and an impeccable solution for organizations dealing with excessive data.
Keywords: Database, Database Management System, Functional Dependencies, Normalization, Relations, Relational Model.