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 3^rd Normal form is the common highest form to reach for business database design. Normalization is connected to the Entity relationship modeling.

Conclusion:

 

Based from the results of the activity, what general rule can you apply for? NORMALIZATION PRIMARY KEY AND FOREIGN KEY