Database Normalization – Normal Forms 1nf 2nf 3nf Table Examples.

It was one of the first things I learnt when I started developing and I mostly work this way. However, I must say that this approach might end up with lots of JOIN queries in your model. Therefore your query is likely to be slower. If your project is not a big one, then believe me no need to seperate those employees as in the example. Querying and fetching just one row is easier and less consumer. But if your project is a big one, of course this way is considered (still not as the best IMHO).

Thanks for sharing