> There are many, many great reasons to break the rules; you > just need > to know what they are so that when you do break them, you are doing > so for a good reason.
For the record, I "break the rules" with one of my more popular commercial applications, just to mirror the structure of the tables I am pulling data from. It is easier for me to correlate the PICK table structures, along with all their insane links, duplicated data in multiple tables, misfired update tragedies, etc., than try to normalize a data structure that is "proper". Kind of running in a "broken parallel architecture" as opposed to running along skew lines, I always know from whence my data comes from the Source structurally, and where it winds up structurally. Luckily Fox is forgiving and fast enough unto itself to let me get away with that approach. Come to think of it, I do not think I ever really did a fully normalized structure <g>... Ad Hoc seems to do me just fine <g>... Gil > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Ed Leafe > Sent: Tuesday, July 24, 2007 2:59 PM > To: [EMAIL PROTECTED] > Subject: Re: [NF] Consulting saga continued or Why Be Normal? > > > On Jul 24, 2007, at 1:11 PM, [EMAIL PROTECTED] wrote: > > > Having 20 to 50 different look up tables for just a description > > text for the user, it's key for usage, and it's status is going to > > be a hard sale for me. Having to adjust an interface with table > > names and column names is going to be a RPITA. Go ahead and tell > > me that it's all meta data. I dare you! ;-> > > Nobody is saying that your design is not efficient; it's just not > normalized according to relational design. > > There are many, many great reasons to break the rules; you > just need > to know what they are so that when you do break them, you are doing > so for a good reason. > > -- Ed Leafe > -- http://leafe.com > -- http://dabodev.com > > > > [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.
