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 less storage space we took up,…