←back to thread

The principles of database design, or, the Truth is out there

(ebellani.github.io)
121 points b-man | 1 comments | 19 May 25 02:58 UTC | HN request time: 0.35s | source
Show context
moi2388 ◴[19 May 25 05:23 UTC] No.44026696[source]▶
“ Principle of Full Normalization (POFN) : Every base relation should be in its highest normal form (3, 5 or 6th normal form)”

No it shouldnt.

replies(2): >>44027041 #>>44030611 #
1. bwfan123 ◴[19 May 25 14:59 UTC] No.44030611[source]▶
I have implemented database schemas, (without knowing database theory), and these principles are a revelation to me.

A question I have is: Given a schema, are there automated verifiers for validating that it adheres to these principles ? A schema "linter" of sorts.

There seem to be parallels to linear algebra here (orthogonal bases, decompositions, etc)