Hi, In my mainframe days we were sent to courses on DB design. There are certain 'Rules' that should be used when deciding which fields to include in which Tables. This link (from my quick glance), appears to be good - http://www.datamodel.org/NormalizationRules.html
Don't sweat it, if you doze off AFTER 3. Most of us didn't bother going past 'Third Normal form' Once one has the design right, there can be situations where the DB design is tweaked for perormance considerations. However, the rule that I follow is - Get it right, and only consider performance if you suspect it will become a problem. Hope this helps, Rob Crombie, [EMAIL PROTECTED] ----- Original Message ----- From: "HouseDad" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, February 16, 2005 12:27 PM Subject: [vbhelp] Re: VisData ---------- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.298 / Virus Database: 265.8.7 - Release Date: 10/02/2005 [Non-text portions of this message have been removed] '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [email protected] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
