I am creating a new website for all the car dealers in my region to show their cars on and i need your opinion on the database I have created because I have some doubts.
For instance, is it best to have a
VehicleID as a foreign key in the
TechnicalSpecifications table or should it be the other way around, like having a
TechSpecID in the
Vehicles table? I am a bit confused and every time I think about it I lose my focus and can't figure it out.
I appreciate your input on my work so far and if you have any comments on anything please do share.