3 ms·
Thank you. Was thinking that I was the clueless one... (probably a little) because that is not my understanding of what normalization is. I thought perhaps sw
by mixmastamyk 5y ago
Thank you. Was thinking that I was the clueless one... (probably a little) because that is not my understanding of what normalization is.
I thought perhaps swapping the strings to integers might make it easier to index, or perhaps it did indeed help with dedupilcation in that the implementation didn't "compress" identical strings in a column—saving space and perhaps help performance.
But both issues appeared to be implementation issues with an unsophisticated Mysql circa 2000, rather than a fundamentally wrong schema.
I agreed with her comment at the end about not valuing experience, but proper databasing should be taught to every developer at the undergraduate level, and somehow to the self-taught. Looking at comptia... they don't seem to have a db/sql test, only an "IT-Fundamentals" which touches on it.