We apologize for a recent technical issue with our email system, which temporarily affected account activations. Accounts have now been activated. Authors may proceed with paper submissions. PhDFocusTM
CFP last date
20 December 2024
Call for Paper
January Edition
IJCA solicits high quality original research papers for the upcoming January edition of the journal. The last date of research paper submission is 20 December 2024

Submit your paper
Know more
The week's pick
Responsive image
Improved Shuffled Frog Leaping Algorithm with Self-Adaptive Shuffling for Fuzzy Logic PD+G Controller Optimization in Robotic Manipulators

Duc Hoang Nguyen
Random Articles
Reseach Article

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

by Manal Fadel Younis
journal cover thumbnail

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.

Powered by PhDFocusTM