Introduce the normalization of data in simplifying the database. Discussion: In order to have a good database,
Question:
Introduce the normalization of data in simplifying the database.
Discussion:
In order to have a good database, the database should have a good table structure which will prevent data anomalies, prevention is better than elimination of data anomalies. Good table structure makes good database design making a better and efficient data representation. Though, it is easy to manipulate unnormalized set it is always a practice that it is not about to lessen the work but to make the work efficient. Normalization is the process of evaluating and correcting the table structure which also represents the company’s real operation. Normalization process has several stages called Normal Forms (NF). The first three stages will be discussed which is actually the 3rd Normal form is the common highest form to reach for business database design. Normalization is connected to the Entity relationship modeling.
Conclusion:
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi