Hung Hoang

What is Database Normalization? Database normalization is an approach to evaluate database structure and minimize data redundancy based on candidate keys and functional dependencies. Candidate keys are unique identifiers that have all the necessary conditions to become a primary key. Functional dependencies refer to the relationship between attributes, where one attribute uniquely determines another. Simply put normalization is a process of eliminating attributes which is not identified by candidate keys . For example, consider a studentnumber  that can uniquely identify a surname and firstname . In this case, the student number acts as a determinant , which determines the surname or firstname. Student ( studentnumber , surname, firstname) The goal of normalization is to group attributes with a close logical relationship into the same table, so that it ensure there is no data redundancy. Benefits: Efficiently retrieve data: Well-structured data allows for faster and more accurat...