The week's pick
Reseach Article
Relational Database Design: A Review
| International Journal of Computer Applications |
| Foundation of Computer Science (FCS), NY, USA |
| Volume 176 - Number 6 |
| Year of Publication: 2017 |
| Authors: Kunal Kumar, Sachindra Kumar Azad |
10.5120/ijca2017915626
|
Kunal Kumar, Sachindra Kumar Azad . Relational Database Design: A Review. International Journal of Computer Applications. 176, 6 ( Oct 2017), 14-18. DOI=10.5120/ijca2017915626
Abstract
Relational Database Designing and Normalization approach is an essential work for the designing of relation up to higher normal form in the field of Database designer. Database Relation stored information into two dimensional matrix form i.e. rows and column. The task of Normalization is to remove data redundancy, data inconstancy and maintain atomicity within the database relation. Key is an attribute of a relation that indentifies the tuple within a database relation, uniquely. This key attribute is generated by applying the closure operations on a given set of functional dependency. Functional dependency of a relation shows the various relations between the attributes and entity relationship diagram shows the prototype of the relation from which designer derived the functional dependency. Relational Database Designing has been spaciously studied and reviewed by many researchers previously; still the works is going on in this area. This paper review the various researches works done earlier in this field and also explain the various applications of Database normalization.
References
- Churcher, Clare, “Beginning database design”, Beginning Database Design, page no 1-240, 2007
- Birney, Ewan Clamp et al., “Biological database design and implementation.”, Briefings in bioinformatics, Vol-5, Issue-1, page no 31-38, 2004
- Chilson, David W. Kudlac, Michael E., “Database design”, ACM SIGMIS Database, Vol-15, Issue-1,page 11-19,1983
- Lightstone, Sam Teorey et al., “Physical Database Design”, Physical Database Design, 10.1016/B978-0-12-369389-1.X5000- 1, 9780123693891, 1860949X, 2007
- Garcia-Molina, Hector Ullman et al., “Database Systems: A Practical Approach to Design, Implementation, and Management”, International Journal of Computer Applications, Vol-49, Issue -4, page 90-107, 2010
- Batini, C.Ceri, S. Navathe, Samkant B, “Conceptual Database Design: An Entity-Relationship Approach”, Database, 9780805302448, 0805302441, page 470,1992
- Storey, Veda C. Thompson et al., “Understanding database design expertise”, Data and Knowledge Engineering, Vol-16, Issue -2, page 97-124, 1995
- Massimo Villari, Antonio Celesti et al., “Enriched E-R Model to Design Hybrid Database for Big Data Solutions”, Management of Cloud and Smart City Systems 2016.
- Moussa Demba,”Algorithm for relational database Normalization up to 3NF”, International Journal of Database Management Systems ( IJDMS ) Vol.5, No.3, June 2013
- Henning Koehler, Sebastian Link, “Armstrong axioms and Boyce–Codd–Heath Normal Form under bag semantics”, Information Processing Letters 110 (2010) 717–724.
- Tauqeer Hussain, Shafay Shamail et al. , “Eliminating Process Of Normalization In Relational database Design”, IEEE, INMIC, 2003
- Ashish Kamra and Elisa Bertino, “Design and Implementation of an Intrusion Response System for Relational Databases”, IEEE Transactions On Knowledge And Data Engineering, VOL. 23, NO. 6, June 2011
- Wenxiu Duan, “Candidate keys Solving Method Based on Boolean Matrix for Single Attribute Functional Dependency Sets”, World Congress on Software Engineering, 978-0-7695-3570-8/0, 2009 IEEE
- Hongbo Li, Li Zhou, “Use closure of relevant sets of attributes to efficiently find candidate keys”, 2008 International Conference on Computer Science and Software Engineering
- H. Bahmani, M. Naghibzadeh et al., “Automatic Database Normalization And Primary Key Generation”, CCECE/CCGEI May 5-7 2008, IEEE
- Zhang Yi-Shun, “Determining All Candidate Keys Based on Karnaugh Map”, 2009 International Conference on Information Management, Innovation Management and Industrial Engineering, 978-0-7695-3876-1/09, 2009 IEEE.
- N. Mendjoge, Abhijit R. Joshi et al., “Intelligent Tutoring System for Database Normalization”, ICCUBEA, page 1-6, 2016
- Savita B. Chava, Dr. B. B. Meshram, “ Study of Various Normal forms and Functional Dependency”, International Journal of Emerging Technology and Advanced Engineering, ISSN 2250-2459, Volume 2, Issue 7, July 2012
- S Vimala1, H Khanna Nehemiah et al., “Design Methodology For Relational databases: Issues Related To Ternary Relationships In Entity-Relationship Model And Higher Normal Forms”, International Journal of Database Management Systems ( IJDMS ) Vol.5, No.3, June 2013.
- Elmasri, Ramez Navathe, Shamkant B, “Fundamentals of Database Systems”, Vol- 28, page 1029, 10.1016/S0026-2692(97)80960-3, 0321122267, 19406029, 2003
Index Terms
Keywords