Normalization Process Within A Database

955 Words4 Pages
Normalization can be used as a methodology for achieving an organized and logically designed database free of overused excessive data. The normalization process includes three integral fundamental steps which are the first normal form, second normal form, and third normal form. Logically organizing data in a manner that reduces or eradicates excessive equivalent data allows for accurate and concise data tracking within a database, and normalization can help achieve this. Normalization as a Methodology for Organizing Attributes into Tables Normalization is used as an organizational methodology to eradicate excessive data and include essential necessary data within a database. There are three levels of the normalization process that include First Normal Form, Second Normal Form, and Third Normal Form. Each normal form is significant to the normalization process in logically designing a database.
Gillenson (2012) states that “Data normalization is a methodology for organizing attributes into tables so that redundancy among the non-key attributes is eliminated” (p. 175). The normalization process can be viewed as a fine-tuning of sorts that can pinpoint and get rid of overused or unnecessary data. The data normalization process includes three steps or levels. These three levels include First Normal Form, Second Normal Form, and Third Normal Form. “Normal forms that guide the process of database schema design have several key goals such as
Get Access