Re: database design questions....
Date: 12 Jul 2001 06:09:31 -0700
Message-ID: <39bb2c10.0107120509.3f69d029_at_posting.google.com>
"Ed Peddycoart" <ed_at_celticblues.com> wrote in message news:<tkbm3j78luui37_at_corp.supernews.com>...
> I am working on a website which will make use of a MySQL database. I know
> little if anything about the best way to design my db for efficiency, or
> anything else for that matter. The information which I need to put in the
> database will be contact/profile information on various people: Name,
> Address, Phone, Email, Marital Status, Spouse, kids, things like that and a
> field for comments submitted from the various people. Right now I have a
> single table with a record for each item I want to store. Is that an
> acceptable way?
>
> What are some websites which contain some basic information on DB design
> etc. Things such as the best way to structure the db for effiency, searches,
> what do all the terms mean (keys, index etc) etc.
>
> Ed
Don't start worrying about efficiency, indexes &cetera until you have
a logical design that correctly models the small part of the world
that is important for your application. The following URL is useful:
http://www.utexas.edu/cc/database/datamodeling/ Received on Thu Jul 12 2001 - 15:09:31 CEST