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.
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.