Stephen, <<What are you smoking? Shipping types are more then just a simple lookup.>>
That was exactly my point. <<They include rates as well as discounts, and date ranges for their use. What part of that are you confusing with a simple TEXT description that I have been speaking of? >> You're just adding complexity. I asked a simple question. If I needed to add another attribute for something called "shipping type" that was currently in your lookup table, what would you do? No matter how you slice or dice it, "shipping type" and "salutation" are not the same thing and don't belong in the same table according to the theory. <<Sorry but the row of data is time oriented. You get a Rate for show on your invoices, your rate, the discount amount, as well as the surcharge. See 3NF below. >> Again, forget about the time and everything else. Your just introducing complexity to a simple question. It really doesn't matter what I wanted to record, just that it was something that does not apply to salutations. What you have is the description and current charge. How would you store it? <<1NF Eliminate Repeating Groups - Make a separate table for each set of related attributes, and give each table a primary key. 2NF Eliminate Redundant Data - If an attribute depends on only part of a multi-valued key, remove it to a separate table. 3NF Eliminate Columns Not Dependent On Key - If attributes do not contribute to a description of the key, remove them to a separate table.>> These are not correct. First, you start with a relation, which is: 1. It describes one entity. 2. There are no duplicate rows. 3. The columns are unordered. 4. The rows are unordered. The Normal forms are: 1NF is that all columns must be atomic, that is a single value. 2NF is that you have 1NF and that all non-key columns are fully dependent on the entire primary key. 3NF is that you have 2NF and that all non-key columns are mutually independent. Jim. <<snip>> _______________________________________________ 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.
