Join Adam Wilbert for an in-depth discussion in this video Reducing redundancy with normalization, part of Database Fundamentals: Storage.
- You won't get very far in 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 computer sciences, the cost of storing data…was far greater than it is today.…So efficiencies were developed in order to maintain the data…in the least amount of space possible.…This lead 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 decades since,…the efficiencies of normalizing your tabular data are still…important due to the sheer volume of data…that's collected today.…
Typically 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 column to apply more than once…to a single record or if an attribute…will, in some cases, not be applicable.…Once you've gotten a clear picture of your data storage…
Note: This course will also prepare certification candidates for the "Understanding data storage" domain of the Microsoft Technology Associate (MTA) Exam 98-364, Database Administration Fundamentals. Find out more at https://www.microsoft.com/learning/en-us/exam-98-364.aspx.
- Reducing redundancy with normalization
- Fixing partial dependencies
- Creating primary keys
- Linking tables with foreign keys
- Creating clustered and nonclustered indexes