Re: Where to find advice on database structure/design?
It might also help to at least try to understand why you normalize. Don't just try to follow the rules, there is some art to it as well. My favorite book on this is "Database Design for Mere Mortals" Thanks, Eric At 09:11 PM 10/22/03 -0700, olinux wrote: >Read up on database normalization. (do a search on >your favorite search engine) It will give you an >appreciation of storing related pieces of info in >different tables. Though you shouldn't need a series >of forms to access the data (most of the time) - this >has more to do with your programming logic. With a >strong understanding of normalization you'll be able >to structure your forms to get the info you want. > >Here's a great site with examples of different data >models. Not all are complete, but a great start and a >great source for ideas. >http://www.databaseanswers.com/ > >olinux > > >--- "Apollo (Carmel Entertainment)" ><[EMAIL PROTECTED]> wrote: >> I have moved our database from Access to MySQL, but >> I did leave same structure. >> Problem is that in our business we deal with >> companies that have multiple >> branches so having it like we have now with sub >> queries and subforms that have >> to look up info from 3 tables to give me one record >> of contact information just >> does not work anymore. Too many forms with subforms >> create huge performance >> problems. >> Anyone can point me to a good reading material (on >> the web or in print) that >> would give me ideas how to deal with this >> overcomplicated way of handling client >> data? >> Thanx, >> Apolinaras "Apollo" Sinkevicius >> Carmel Music & Entertainment, LLC >> web-site: http://carmelme.com >> >> Having an event in Chicago, or would you like to >> bring Chicago entertainment >> to your event? Give Carmel Music & Entertainment a >> call for the finest >> entertainment available in Chicago. >> >> - >> Visit CARMEL MUSIC & ENTERTAINMENT website >> http://carmelme.com >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] >> > > >__ >Do you Yahoo!? >The New Yahoo! Shopping - with improved product search >http://shopping.yahoo.com > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > (250) 655 - 9513 (PST Time Zone) "Inquiry is fatal to certainty." -- Will Durant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Where to find advice on database structure/design?
Read up on database normalization. (do a search on your favorite search engine) It will give you an appreciation of storing related pieces of info in different tables. Though you shouldn't need a series of forms to access the data (most of the time) - this has more to do with your programming logic. With a strong understanding of normalization you'll be able to structure your forms to get the info you want. Here's a great site with examples of different data models. Not all are complete, but a great start and a great source for ideas. http://www.databaseanswers.com/ olinux --- "Apollo (Carmel Entertainment)" <[EMAIL PROTECTED]> wrote: > I have moved our database from Access to MySQL, but > I did leave same structure. > Problem is that in our business we deal with > companies that have multiple > branches so having it like we have now with sub > queries and subforms that have > to look up info from 3 tables to give me one record > of contact information just > does not work anymore. Too many forms with subforms > create huge performance > problems. > Anyone can point me to a good reading material (on > the web or in print) that > would give me ideas how to deal with this > overcomplicated way of handling client > data? > Thanx, > Apolinaras "Apollo" Sinkevicius > Carmel Music & Entertainment, LLC > web-site: http://carmelme.com > > Having an event in Chicago, or would you like to > bring Chicago entertainment > to your event? Give Carmel Music & Entertainment a > call for the finest > entertainment available in Chicago. > > - > Visit CARMEL MUSIC & ENTERTAINMENT website > http://carmelme.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Where to find advice on database structure/design?
I have moved our database from Access to MySQL, but I did leave same structure. Problem is that in our business we deal with companies that have multiple branches so having it like we have now with sub queries and subforms that have to look up info from 3 tables to give me one record of contact information just does not work anymore. Too many forms with subforms create huge performance problems. Anyone can point me to a good reading material (on the web or in print) that would give me ideas how to deal with this overcomplicated way of handling client data? Thanx, Apolinaras "Apollo" Sinkevicius Carmel Music & Entertainment, LLC web-site: http://carmelme.com Having an event in Chicago, or would you like to bring Chicago entertainment to your event? Give Carmel Music & Entertainment a call for the finest entertainment available in Chicago. - Visit CARMEL MUSIC & ENTERTAINMENT website http://carmelme.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]