Smendle (7/14/2011)
Great article, didnt read any previous articles before (assuming you started at 1). It should be noted that with any production DB system, even one that seems simple, changing it to conform to DB Normalization rules will create a lot of other work like fixing queries against said DB, reports will be broken, space will increase etc...
True. However to play devil's advocate:
- the report is already "broken" since it (potentially) returns bad data.
- space usage would likely DECREASE, since you're not duplicating all of the employee-dependent data.
It's definitively a non-trivial task to do this after the fact, but - there is a gain to be found in there.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?