Write A Paper Of 500 800 Words About Normalization

Database NormalizationNameInstitutional affiliationDatabase NormalizationNormalization is a process of effectively organizing the data in a relational database, usually into tables to eliminate ambiguity by ensuring that data is properly defined, and also to avoid storing the same data several times within the same database. The database designer establishes the relationship between the data in one table and another in the same or a different table to enhance data dependence. This refers to the scenario where data stored in one table uniquely defines data stored in the same table. For instance, the student’s university registration number identifies the name of the student, the hall of residence, health information among others. Therefore, without normalizing a database, it would be tedious to update database information, which may result in errors.Normalization formsRelational databases can be normalized in three ways; the first normal form (1NF), the second normal form (2NF) and the third normal form (3NF). The 1NF is the most basic form of database normalization. It organizes data into two dimensional tables consisting of rows and columns (Whitehorn & Marklyn, p. 216, 2007). The rows contain the records while the columns contain the