database design questions....

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 Received on Fri Jul 06 2001 - 12:23:41 CDT