• ejoell 66477 (4/11/2013)


    @majorbloodnock

    Concerning your remark from July 2008 about CS degreed folks having a better grasp of DB theory.

    In my experience that has not been necessarily the case. Even though there is a lot of valuable information in "Book Larnin' ", I've found that these people have a tendency to create the most insanely complex databases with data stored in the fifth Normal form and five part primary keys and the worse in my opinion, manually-entered data used as the primary key.

    I don't know how many times I've seen people traisping all through a database tracking down foreign keys to fix fat-fingered data. Whereas if that had been made a unique key with a generated primary key it would have only needed to be changed in one location.

    On each occasion, the db designer reported that was what he or she had learned in college. So I've always had a biased viewpoint of college DB courses. I much prefer someone with experience with a knowlege of what not to do and why.

    Sorry, but I think you'll find it was PollockK who wrote that one - the post just before my one. Mind you, it was not far off 5 years ago, so I had to go searching to refresh my memory..... 😀

    Personally, I've seen both heavily over- and under-normalised databases and most of the related problems actually come to pass. I obviously try to find the happy medium, sometimes even getting it right. For the record, I don't have an IT related degree.

    Semper in excretia, suus solum profundum variat