Link to home
Start Free TrialLog in
Avatar of afflik1923
afflik1923Flag for United Kingdom of Great Britain and Northern Ireland

asked on

SQL (mysql)- normalization advice - Best way to design clients / suppliers tables

Hi,
I'm building a new database in PHP / MySQL.

I have often wondered this and wanted to know what others think.

Lets say I'm building a "suppliers" table which holds information about a companies different suppliers.
I'm trying to decide if to build fields such as email address, and telephone numbers into the main suppliers table or whether to create a one to many relationship with a number of subtables.

In most cases suppliers will only have one email address or one main address but there are cases when they will have more.

therefore is it good practise or overkill to build the database table so in fact there are additional tables such as

"postal address"
"email_address"
"telephone_numbers"
all as seperate tables.

then I could even go further and use these tables for other entites such as "customers" etc.

Is this good advice or am I creating unnecessary complexity? is this just going to slow down my database performance and make coding harder as always having to think about linking the tables?

Thanks for any opinion.
SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of afflik1923

ASKER

All good comments and a good link. Thank you for your contributions.