Relational Database Normalization under Tabular Approach: A Design Methodology

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.