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!

IWETHEY Home / IWETHEY Board / Databases Forum / Thoughts...
Post #101,209
by Simon_Jester
5/10/03 11:56:00 AM
Reply
New Thoughts...
You're going from a 3rd normal form (possibly higher) to a single table. Generally speaking it's a bad idea in the database world (but - there are exceptions).

However, given your data, something is indeed strange. Why the hell are there 3 autoincrementing identifiers? The identifier for state (primary key) should be the 2 letter code (and nothing else). County should be a FK (state cd) with no primary (imo).

But that's just my opinion. YMMV
Post #101,398
by drewk
Picture of drewk
5/12/03 7:35:55 AM
Reply
New You've about got it
All we need in the primary table is the state and county foreign keys.[1] It looks like someone had just taken a class in normalization and went a little bit crazy.




[1] Actually just the county one, because the state is encapsulated within it, but I don't want to get Scott started again. ;)
===

Implicitly condoning stupidity since 2001.
     Is this schema screwed up, or is it just me? - (drewk) - (16) - May 7, 2003, 09:50:41 AM EDT
         Your new schema looks good. - (jbrabeck) - (2) - May 7, 2003, 10:31:20 AM EDT
             I guess what I'm looking for is ... - (drewk) - (1) - May 7, 2003, 10:46:26 AM EDT
                 Guessing - (jbrabeck) - May 7, 2003, 10:57:34 AM EDT
         Dependent Foreign Keys - (ChrisR) - (10) - May 7, 2003, 10:58:46 AM EDT
             Can't happen, each county is unique - (drewk) - (9) - May 7, 2003, 11:05:16 AM EDT
                 Still a function of integrity - (ChrisR) - (8) - May 7, 2003, 11:15:42 AM EDT
                     Don't even need a lookup table - (drewk) - (7) - May 7, 2003, 11:18:53 AM EDT
                         Maybe it's just me - (tseliot) - (6) - May 7, 2003, 11:46:48 AM EDT
                             Agreed. - (admin) - (5) - May 7, 2003, 11:51:52 AM EDT
                                 That's how I've already set it up - (drewk) - (4) - May 7, 2003, 12:35:35 PM EDT
                                     It's not a matter of speed. - (admin) - (3) - May 7, 2003, 12:41:23 PM EDT
                                         Generally I agree - (drewk) - (2) - May 7, 2003, 12:43:59 PM EDT
                                             Even so. - (admin) - May 7, 2003, 02:35:22 PM EDT
                                             I agree with Malraux on this one - (tablizer) - May 22, 2003, 02:00:35 AM EDT
         Thoughts... - (Simon_Jester) - (1) - May 10, 2003, 11:56:00 AM EDT
             You've about got it - (drewk) - May 12, 2003, 07:35:55 AM EDT

No, Mr. Bond! I expect you to die!
40 ms