Greetings,
I read about database normalization and I knew that there are 8 normal forms to follow. I understand the 3 first normal forms, however, I did not understand the other 5 normal forms and they are:
1- BCNF - Boyce-Codd Normal Form
2- 4NF
3- 5NF
4- ONF - Optimal Normal Form
5- DKNF - Domain Key Normal Form
Can anyone please explain to me those normal forms with a simple example.
Best Regards
Small world. Many years ago I was tasked with speeding up a database system. Turned out we denormalized it.
Many articles on the web abotu your 5 items but had to comment that normalization may not be what you want in every situation.
More at https://www.google.com/search?hl=en&as_q=denormalization+in+database
Greetings,
Thanks for the reply but the link switches me to topics about de-normalization and I was asking about normalization not de-normalization :), however, the link for sure will have some useful topics and it may be of interest when switching from normalization to de-normalization. The problem for the 5 normal forms I mentioned above is that many people do not know about as they focus of the first 3 normal forms.
Well Wikipedia has a good example on these. Did you not see it? Even I understood it. Not that I'd ever think of implementing most of them intentionally.
bcnf is very uncommon, i wouldnt worry about that too much
Tons of posts, blog, articles, wiki are there on internet go find them. Sitepoint, w3school, stackoverflow are few sites you go for!
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.
