This is purely a thought exercise at this point. A local gas station/garage near me just closed up shop (The owners got in hot water with the law and I believe may be in jail right now...
As the name implies, I have an auto repair shop and I'd like some pointers on how to set up a database for keeping track of customers and their info (names, addresses, numbers, vehicles, etc.), parts purchasing, invoicing, etc. I've learned quite a bit from sheepdog's website regarding the basics of databases, but I'm not sure exactly where to start with my project.Among other things, here's what I want from an invoice:I want to input a vehicle's year of manufacture, then I want to select a manufacturer from a dropdown list, then I want a dropdown list containing only those models available in that year, from that manufacturer.I have lists of both manufacturers and models already.What I need to know is: do I combine them into one table or would it be wise to have one table for 'make' and one table for 'model' ?Why go with one table instead of two, or visa-versa?I'm fairly computer literate, though I'm new to databases.
Any help will be apprecited.
I didn't find the right solution from the Internet.