From the course: SQL Server 2014: Developing Databases

Unlock the full course today

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

Reviewing database normalization

Reviewing database normalization - SQL Server Tutorial

From the course: SQL Server 2014: Developing Databases

Start my 1-month free trial

Reviewing database normalization

- Reviewing database normalization. Now I say "reviewing" because normalization is a large subject, and there's books written on just this concept of normalization. So, what is normalization? Well, the idea of normalization is to prevent anomalies, and there are three types of anomalies. There's insertion, deletion, and update anomalies. And this really means that changing the design of the table or the database, so that when we do the normal functions, they're called CRUD, by the way, create, read, update, and delete. So when we create a record, which is an insertion, or when we delete one or update one, we don't damage the rest of the database so that it's not really a reflective of the information we want. There are different degrees of normalization. So why not one huge table? Well, when relational databases were first put forward, the largest cost factor of the big three, which is processing power, memory, and storage, was storage. So the more we could compress storage, or the…

Contents