Normalizing a database

by Polun L
The article, “Relational Database Normalization Process”, talks about normalization standing an important role in the relational database because it ensures data are logically stored, eliminates duplicated data, and increases the speed of processing data, so that database system can be accurate and efficient. When a database is normalized, the article suggests users to start from the general and work towards the specific because normalization is formed from several rules called “normal forms”. In each level of normal form, the articles shows the table of how each level of form should be and provides the explanation and summary of each form. At the end, it gives readers a review of all the important terms with full explanation such as three types of relationships between entities, primary key and foreign key.

 

Response:

What I like about this article is that it explains the functionality of normalization process in a very detailed way and then bold the key words which are very easy for me to catch the main point when I re-read the article. Also, it points out the consequence between a good database design and a bad database design. It apparently wants us to understand that if we did not spend time on building a good database, we would encounter a lot of obstacles at the end. Furthermore, the article provides an example and summary of the normalization forms (1st, 2nd, and 3rd) which helps me better understand the concept of each level of normalization form. This article does not only mention the key words, but it also provides a full explanation of each terms.

Reference:

(n.d.). Relational database normalization process. Retrieved from http://www.databasedev.co.uk/database_normalization_process.html

In Text:

(“Relational database normalization,” )

1 thought on “Normalizing a database”

  1. Good database design is crucial in creating an efficient and scalable database. In my article, Benchmark Factory gives an advantage by being able to test out designs and settings making it easier to find the right design.

Comments are closed.