From the course: Database Foundations: Data Structures

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Protect data integrity with normalization

Protect data integrity with normalization

From the course: Database Foundations: Data Structures

Start my 1-month free trial

Protect data integrity with normalization

- [Instructor] You won't get very far on the path of database development before you run across the term, database normalization. Normalization is the process of removing redundancy from a database. At the dawn of the computer sciences, the cost of storing data was far greater than it is today, so efficiencies were developed in order to maintain data in the least amount of space possible. This led to the development of normalization rules, or what's referred to as normal forms. While the cost of storing and accessing data in a database have decreased dramatically in the past decades, the efficiencies of normalizing your tabular data are still important due to the sheer volume of data that's collected today. The process of normalizing your database first requires you to think about the types of information that you need to store. You'll want to ask yourself if it's possible for a certain attribute, or a group of columns, to…

Contents