Normalization Definitions | Database Management System

Normalization Definitions | Database Management System

There can be many definitions/explanation for normalization. Some of them are as follows:

  • As stated earlier, normalization is a process of decomposing a relation, having certain functional dependencies among its attributes, into smaller simpler relations that are free from anomalies but preserves original FD’s and constraints. The decomposition is such that original set of records can always be brought back by the join of such smaller decomposed relations.
  • Database normalization is a process by which an existing schema is modified to bring its component tables into compliance with a series of progressive normal forms. The Concept of database normalization was first introduced by Edgar Frank Codd.
  • The goal of database normalization is to ensure that every non-key Column in every table is directly dependent on the key, the whole key and nothing but the key and with this goal come benefits in the form of reduced redundancies, fewer anomalies, and improved efficiencies. While normalization is not the be-all and end-all of good design, a normalized schema provides a good starting point for further development.
  • Primarily a tool to validate and improve a logical design so that it satisfies certain constraints that avoid unnecessary duplication of data.
  • The process of decomposing relations with anomalies to produce smaller, well-structured relations.
  • Normalization is a set of formal conditions that assure that a database is maintainable.
  • The results of a well executed normalization process are the same as those of a well planned E-R model.
  • In relational database theory, normalization is the process of restructuring the logical data model of a database to eliminate redundancy, organize data efficiently, reduce repeating data and to reduce the potential for anomalies during data operations. Data normalization also may improve data consistency and simplify future extension of the logical data model. The formal classifications used for describing a relational database’s level of normalization are called normal forms (abbrev. NF).
  • The process by which we efficiently organize data to achieve these goals:
    *Eliminating redundancy
    *Ensuring data is stored in the correct table
    *Eliminating need for restructuring data lase when data is added.
  • Normalisation is the process for deciding which attributes should be grouped together in a relation. It is use to validate and improve logical design to satisfy certain constraints – avoid unnecessary duplication of data. It is the process of decomposing relations with anomalies to produce smaller, well-structured relations.