New to database creation...Where should I start?
New to database creation...Where should I start?
(OP)
I've worked with simple databases before. They were glorified spreadsheets. Now I'm working on something more complicated. I may be over thinking this, but can't figure out what to do. Here is my goal:
Create a database of junk cars by make, model, and year. (I can do this part)
Create an inventory of parts available in each car. (This is where I strugle)
When I query for a car, I want to see all parts available in the car. When a part is sold, I want to mark it as unavailable so that the next query will not show it.
I will be using VB.net to query the Access database. I can convert over to MySql if you think it is necessary. I will gladly read a book or another website if you have a good recommendation. I just haven't been able to find anything yet.
Create a database of junk cars by make, model, and year. (I can do this part)
Create an inventory of parts available in each car. (This is where I strugle)
When I query for a car, I want to see all parts available in the car. When a part is sold, I want to mark it as unavailable so that the next query will not show it.
I will be using VB.net to query the Access database. I can convert over to MySql if you think it is necessary. I will gladly read a book or another website if you have a good recommendation. I just haven't been able to find anything yet.
RE: New to database creation...Where should I start?
RE: New to database creation...Where should I start?
You need to map out the functionality that you want in your system. For example, are the parts being sold and, if so, do you want to include some point-of-sale functionality in the system? If you are selling them do you want to be able to report sales or in-stock levels? What you are constructing is basically an inventory system and there are many examples out there describing the entities that are usually included in such a system. Try a search for "Inventory System Template"