I figure that since this is a dev blog, I should write something devvy.
So I’d like to share with you my knowledge of db normalization, and how to achieve Normal Form Nirvana.
I’d like to introduce what is called Scott Normal Form. It is always the highest possible Form. It has the following properties:
- Does not depend on any nthNF.
- Has absolutely no redundancy. Okay maybe a little bit of redundancy.
- Sets of values can be stored in a column rather than being atomic, as long as it’s a smarter implementation than atomicity.
- Every table has a primary key id, not because it’s always needed but rather because why the hell not.
Now that you know how to normalize a database, go build some cool stuff.