alksjoflkajsom

4 ms·

1. 1.▲
   by alksjoflkajsom 5y ago

   Okay, this will be my last comment in this thread because I don't have any new way of presenting this and checking this is not a good use of my time. This schema is also in Boyce-Codd normal form. It's normalized in every usual
2. 2.▲
   by alksjoflkajsom 5y ago

   >> Mapping the string "address1@foo.bar" to a new value "id1" has no effect on the relations in your table. >How do you mean? If id1 is unique on table A, and table B has a foreign key dependency on A.id, then
3. 3.▲
   by alksjoflkajsom 5y ago

   That's not what normalization normally means, no. See eg wikipedia https://en.wikipedia.org/wiki/Database_normalization
4. 4.▲
   by alksjoflkajsom 5y ago

   You might be right (I don't actually know what a HELO string is, I don't know anything about SMTP :). I was just going off how the author presented the data, as a tuple of four completely independent things. Of course the main poi
5. 5.▲
   by alksjoflkajsom 5y ago

   People in the comments are getting (rightfully) outraged about the poor understanding of indexing, but I'm a little surprised that everyone here doesn't seem to understand normalization either. The original schema is perfectly nor
6. 6.▲
   by alksjoflkajsom 5y ago

   >Managers are getting a pretty bad rap in these threads, and maybe (or maybe not) in BigCo’s that’s reasonable, but I run a tiny shop and I’ve asked my team to come to the office as often as possible, despite the fact that half of us hav