IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New Your new schema looks good.
That's how I would have designed it in the first place.
[link|mailto:jbrabeck@attbi.com|Joe]
New I guess what I'm looking for is ...
Is there any possible reason to have it structured the way it is now? I don't usually like to change things until I understand why they're the way they are to begin with. Problem is the guy who built this is long gone, and it's entirely possible he was just an idiot.
===

Implicitly condoning stupidity since 2001.
New Guessing
Over normalized. When normalizing, keep going until all redundant data is removed. Then look at results to see if usage would be enhanced/performance increased by some "denormalization".

If you always need the county AND state then they both should be in the data table instead of requiring a lookup to find the state.

Looks like the developer didn't perform final analysis.
[link|mailto:jbrabeck@attbi.com|Joe]
     Is this schema screwed up, or is it just me? - (drewk) - (16)
         Your new schema looks good. - (jbrabeck) - (2)
             I guess what I'm looking for is ... - (drewk) - (1)
                 Guessing - (jbrabeck)
         Dependent Foreign Keys - (ChrisR) - (10)
             Can't happen, each county is unique - (drewk) - (9)
                 Still a function of integrity - (ChrisR) - (8)
                     Don't even need a lookup table - (drewk) - (7)
                         Maybe it's just me - (tseliot) - (6)
                             Agreed. - (admin) - (5)
                                 That's how I've already set it up - (drewk) - (4)
                                     It's not a matter of speed. - (admin) - (3)
                                         Generally I agree - (drewk) - (2)
                                             Even so. - (admin)
                                             I agree with Malraux on this one - (tablizer)
         Thoughts... - (Simon_Jester) - (1)
             You've about got it - (drewk)

Holy String Unravelling, Batman!
47 ms