I have been asked to create a website for a company that sells trailer hitches and all related accessories.
They carry several manufacturers' hitches.
I'll need to create a hitch finder that will prompt the user for the year, make and model of the vehicle.
I then need to display all hitches from all manufacturers for that vehichle and display links to see wiring harnesses, and related accessories for that vehicvle that will not require a new search.
The database must also be structured so that an Excel file can be used to upload new data (with the exception of images).
Do I need a table for years, and table for makes and a table for models? Even if I do, how do I link that data to a table of hitches? Once this is figured out, I'm sure the same schema can be applied to wiring harnesses, etc.
I am struggling with how to design the required table(s) needed for this project. I do not know where to start.