Stephen, <<Bull!>>
Like I said, I've been down this road<g>. <<Trust me they are all Normalized to a single table>> No, they are not. Let me ask you a question. Let's say you currently have salutations and shipping types in a single lookup table. Your are asked to add a shipping and handling charge based on the shipment type (ie. UPS ground, Air, etc). Do you: 1. Add a column in your lookup table to hold the S&H charge and leave it NULL for every lookup that is not of the type "Shipping" Or 2. Do you break out the shipping lookups into a separate table. If so, why? Also one of the things I'd like to add is that you must keep in mind is that relational theory is actually a branch of mathmatics. It doesn't exist becasuse of computer database systems, but it is applied to them. To make that clearer, if I wanted to track data using nothing more then a chalkboard, I could do so and still apply relational theory to the process. Jim. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen the Cook Sent: Monday, July 23, 2007 8:48 PM To: [EMAIL PROTECTED] Subject: RE: [NF] Consulting saga continued or Why Be Normal? Jim Dettman <> wrote: > I just went down this road not too long ago. All I can say is; > it's nice to be in control<g>. > > Strictly speaking, a single table for lookup values is not > normalized. > What your doing with the procedures below is to move part of the > normalization into your code rather then having it in the database > design. Bull! Dude, I have 5 set up tables that are all identical. Pkey, Description, and other associated crap for table correctness. Trust me they are all Normalized to a single table, and to have table for 4, 3, or 7 rows each is just to funny. IMO. Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 "A good way to judge people is by observing how they treat those who can do them absolutely no good." ---Unknown http://spaces.msn.com/members/srussell/ No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.10.14/912 - Release Date: 7/22/2007 7:02 PM [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
