Displaying 1 result from an estimated 1 matches for "carmodels".
Did you mean:
carmodel
2006 Mar 22
3
Parent-Child Tables Help
can someone help me with this
i have a table
cars
(
id int
model_id int
make_id int
color_id int
description text
constraint fk_cars_carmake foreign key(make_id) references
carmakes(id),
constraint fk_cars_carmodel foreign key(model_id) references
carmodels(id),
constraint fk_cars_color foreign key(color_id) references colors(id)
)
carmakes
(
id int
carmake varchar
)
carmodels
(
id int
carmake_id int
carmodel varchar
)
colors
(
id int
color varchar
)
Carmakes and Carmodels
- A carmake may be Toyota, Honda etc.
- A carmodel may be Corrola,...