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
From the course: Database Foundations: Data Structures
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.