CFP last date
22 April 2024
Reseach Article

Automating the Lower and Higher Normal Form Process for the Database Systems

by Manal Fadel Younis
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 100 - Number 12
Year of Publication: 2014
Authors: Manal Fadel Younis
10.5120/17576-8050

Manal Fadel Younis . Automating the Lower and Higher Normal Form Process for the Database Systems. International Journal of Computer Applications. 100, 12 ( August 2014), 13-18. DOI=10.5120/17576-8050

@article{ 10.5120/17576-8050,
author = { Manal Fadel Younis },
title = { Automating the Lower and Higher Normal Form Process for the Database Systems },
journal = { International Journal of Computer Applications },
issue_date = { August 2014 },
volume = { 100 },
number = { 12 },
month = { August },
year = { 2014 },
issn = { 0975-8887 },
pages = { 13-18 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume100/number12/17576-8050/ },
doi = { 10.5120/17576-8050 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T22:29:46.746312+05:30
%A Manal Fadel Younis
%T Automating the Lower and Higher Normal Form Process for the Database Systems
%J International Journal of Computer Applications
%@ 0975-8887
%V 100
%N 12
%P 13-18
%D 2014
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Normalization is an important technique for the analysis of relational databases. It aims to create a set of relational tables with minimum data redundancy that preserve consistency and facilitate correct insertion, deletion, and modification. It is very much time consuming to do this data analysis manually. Thus in this paper, a system is proposed which aims to automate the most complex phase of the database design normalization. It will help to achieve a good database design and eliminate the drawbacks of manual normalization process. This system is suitable to eliminate redundancy and inconsistent dependency automatically. It aims to handle the normalization process up to fifth normal. This includes creating tables and establishing relationships between those tables by using their general definitions in a step-by-step feature on the set of functional dependencies to remove redundant data. Then this system is tested on many examples with multiple candidate keys taken from different sources.

References
  1. Coronel C. , Morris S. , and Rob P. 2011. Database Systems: Design, Implementation, and Management, United States of America, 9th edition, 175-197.
  2. Demba M. 2013. Algorithm for Relational Database Normalization up to 3NF, International Journal of Database Management Systems ( IJDMS ) 5(3): 39-40, June.
  3. Sushant S. Sundikar Introduction to Database Management System.
  4. Ryan K. , Ronald R. , 2001. Database Design, United States of America, 208-216.
  5. Sushant. S. Sundikar Introduction to Database Management Systems, 5-8.
  6. Verma S. 2012. Comparing manual and automatic normalization techniques for relational database. IJREAS, 2(2): 59-67, Feb.
  7. Bahmani A, Naghibzadeh M. , Bahmani B. 2008. An Automatic Database Normalization – Primary Key Generation, IEEE.
  8. Alappanavar B. , Radhika P. , Hunjan S. , Girnar Y. 2013. An Ameliorated Approach towards Automating the Relational Database Normalization Process. International Journal of Engineering and Advanced Technology (IJEAT) ISSN: 2249 – 8958, 2(4), April.
  9. Sunitha G. , Jaya A. 2013. A Knowledge Based Approach for Automatic Database Normalization ISSN: 2278 – 1323 International Journal of Advanced Research in Computer Engineering & Technology (IJARCET) 2(5), May.
Index Terms

Computer Science
Information Sciences

Keywords

Functional Dependency Keys Redundancy Normal Forms.