I am trying to setup a DB for an automotive site:
I have Fuel, Gearbox, Type, Price and instock as my tables, but do not know/understand how to set up the DB for child
Do I: Fuel as parent: id_fuel, fuel
Gearbox as child: id_gearbox, id_fuel (Secondary key), gearbox
Type as child: id_type, id_fuel (Secondary key), type
and so on using fuel as the secondary key?
thanks in advance