Hi,
Try to keep the simple attributes in one table and the repetitions in
separated tables>
For example:
A person has only one gender, one name, one marital stauts , etc....
however a person can have none,one or more than one kid. Create another
table and create a relationship between both.
I really don't know how many addresses you want to store for each person but
if it's not that many. keep them in the same table.
Create fields for streetwork, citywork, ststework, etc...
and streethome, cityhome, etc...
This allows you to store only one professional and one home adresses.
If you want more than that ...then put them in a separated table as I
suggested to do for kids
I don't have an example similar to your need but you can take a look at my
website at:
www.geocities.com
and maybe get some ideas from the example I posted there.
click tutorials and team5.com ecommerce sample.
good luck
Siomara
>From: "Ed Peddycoart" <[EMAIL PROTECTED]>
>To: "MySQL" <[EMAIL PROTECTED]>
>Subject: db design questions
>Date: Fri, 6 Jul 2001 10:25:42 -0700
>
>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
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
