sorry I typed my website wrong. The right url is:
www.geocities.com/hisiomara
>From: "Siomara Pantarotto" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED], [EMAIL PROTECTED]
>Subject: Re: db design questions
>Date: Fri, 06 Jul 2001 18:07:36 -0300
>
>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
>
_________________________________________________________________________
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
