| ▲ | iFire 5 hours ago | ||||||||||||||||
https://en.wikipedia.org/wiki/Essential_tuple_normal_form is cool! Since I had bad memory, I asked the ai to make me a mnemonic: * Every * Table * Needs * Full-keys (in its joins) | |||||||||||||||||
| ▲ | petalmind 3 hours ago | parent [-] | ||||||||||||||||
I have so many questions about that. Should that normal form basically replace 5NF for the purposes of teaching? Why do they hate us and do not provide any illustrative real-life example without using algebraic notation? Is it even possible? I just want to see a CREATE TABLE statement, and some illustrative SELECT statements. The standard examples always give just the dataset, but dataset examples are often ambiguous. > (in its joins) Do you understand what are "its" joins? What is even "it" here. I'm super frustrated. This paper is 14 years old. | |||||||||||||||||
| |||||||||||||||||