normalization help
Posted: Sun Oct 24, 2010 6:55 am
Hi, im new to php and mysql and im working on my first mini project to help me progress my knowledge and skills.
im building a simple carwash/valeting website that allows users to provide contact details and details of their car
ive created 3 tables as below,
contact details
make
model
how should i link the make and model table to the main contact details table, would i also need a 4th table to link the make and models together?
the intention is to have some kind of fee scale/band linked to the model of car ie big car will cost you more. to then complicate matters further the existing condition of the car will also +/- a percentage ie bad condition will cost you more
please could someone provide some assistance to get me started, i really want to do things correctly, rather than just stick everything in one/two tables
thanks
Rob
im building a simple carwash/valeting website that allows users to provide contact details and details of their car
ive created 3 tables as below,
contact details
make
model
how should i link the make and model table to the main contact details table, would i also need a 4th table to link the make and models together?
the intention is to have some kind of fee scale/band linked to the model of car ie big car will cost you more. to then complicate matters further the existing condition of the car will also +/- a percentage ie bad condition will cost you more
please could someone provide some assistance to get me started, i really want to do things correctly, rather than just stick everything in one/two tables
thanks
Rob