Relational Database Normalization under Tabular Approach: A Design Methodology
Main Article Content
Abstract
Relational Database Design and normalization, is a collection of processes that ensure the representing, development, interpreted and maintenance of enterprise records and data management systems. It also helps to produce effective database management systems. That meets the requirements of the end users and has high performance. Normalization approach uses to reduce data redundancy, inconsistency and maintain the atomicity within a database relation. In this paper, A Tabular approach process is proposed to determining key(s) from set a given set of functional dependencies. The moment, it determine the key(s) of a relation from a set of functional dependency. It shows an automatic generation of all possible candidate key(s) and super key(s) of a relation. In the proposed method, a table has three columns and one row. This column and row of the table contains the given set of functional dependency. Once, putting all possible valid set of functional dependency into the tabular form, then using tabular method approach mechanisms applying to determine key(s) of a relation. Key of a relation is used to help to reach higher level of relational database design.
Downloads
Download data is not yet available.
Article Details
Section
Articles
COPYRIGHT
Submission of a manuscript implies: that the work described has not been published before, that it is not under consideration for publication elsewhere; that if and when the manuscript is accepted for publication, the authors agree to automatic transfer of the copyright to the publisher.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work
- The journal allows the author(s) to retain publishing rights without restrictions.
- The journal allows the author(s) to hold the copyright without restrictions.