Database normalization design pattern
Kunal Kumar, Sachindra Kumar Azad · 2017 4th IEEE Uttar Pradesh Section International Conference on Electrical, Computer and Electronics (UPCON) · 2017
Normalization is a database design technique, which is used to design the Relational Database table up to higher normal form. The main aim of the database normalization approach is to reduce data redundancy and maintain the atomicity within the database table. In this paper, The Tabular approach algorithm method is introduced to generating candidate key from set a valid set of functional dependency. Once, it determines the candidate key of a database table from a given valid set of functional dependency, and then applying normalization algorithms we can easily achieve higher level of normal form. It also shows new tabular based automatic generation of all possible super key and candidate key of a database table. A tabular approach algorithm method have table, having three columns marked as left, middle and right and one row. This column contains the valid set of given functional dependency. Once, we feed the column of the tabular approach table marked as left, middle and right with all possible valid set of functional dependency, then using proposed tabular approach algorithm method used to determine candidate key(s) and using these key(s), we can reach higher level of normal form.