database design questions....
Date: Fri, 6 Jul 2001 10:23:41 -0700
Message-ID: <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