New to database creation...Where should I start?

[chris86t]

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.

 

[chris86t]

Just realized I put this in the wrong place. Please move/close this topic. I will re-submit in the proper area.

 

[Golom]

I would start by learning the lingo for relational databases. Fundamentals of Relational Database Design is a good overview.

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"