2 ms·
" Every base relation should be in its highest normal form (3, 5 or 6th normal form). " If I remember my database lessons correctly there is no strictly highes
by weinzierl 1y ago
" Every base relation should be in its highest normal form (3, 5 or 6th normal form). "
If I remember my database lessons correctly there is no strictly highest normal form. It progresses from 1NF to BCNF, but above that it is more choosing different trade-offs.
Even below it is always a trade-off with performance and that is why we most of the time aim for 3NF, and sometimes BCNF.
- moi2388 1y agoThat’s what I was taught as well. And even then I use it more as a rule of thumb
- plank 1y agoThere are big disadvantages from choosing e g. 5th normal form: any changing in business requirements leads to a big rewrite and data conversion. Never seen successful projects choosing beyond 3rd/BCNF.