hello, continuing my quest to build a better database, i'd like to ask a question that i haven't been able to find an answer to. here is an excerpt from an article on evolt (http://www.evolt.org/article/Beginning_Database_Design_Part_I/18/27137/ ): (and where i got the idea as well)
"You'll probably see some duplicate field names, such as 'Name' in both the 'Companies' and 'People' tables. Let's make them unique across the database. You might choose 'ContactName' and 'CompanyName' but whatever you use, stick to the guidelines above, and be consistent." is this person suggesting that *all* fields within the 'Companies' table be prepended with "Company" (i.e. CompanyName, CompanyAddress1, CompanyZip, etc.) or is he suggesting that only fields which have the same name in multiple tables have "Company" added? THIS: +---------------------+ | COMPANIES | +---------------------+ | CompanyName | | CompanyDate | | CompanySize | +---------------------+ +---------------------+ | CONTACTS | +---------------------+ | ContactName | | ContactHeight | | ContactWeight | +---------------------+ OR THIS: +---------------------+ | COMPANIES | +---------------------+ | CompanyName | | Date | | Size | +---------------------+ +---------------------+ | CONTACTS | +---------------------+ | ContactName | | Height | | Weight | +---------------------+ Thank you for your time. Chris. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]