Hello, this is my first attempt with databases and I would like some advice on the best way to set up my tables with the data I have, here is my situation.
I have a small business that rents equipment, I have created my customer table but not sure where to go from here, each customer may or may not have rented out several different things at the same time but could only have one rented out, I thought about making an equipment table and using a drop down box for each item rented but my equipment that I have for rent is always changing from month to month so I always have different types of stock so I am not sure how to handle this, I guess it would be easier to list what I need.
1. list of customers
2.ability to track what customer has rented out
3.need to be able to track how many of x has rented out in any given amount of time.
4.pictures of equipment rented out.
5.photo of customer.
6.would like to be able to see how many of x has rented out by county or city or even zip code.
I guess that is about it and thanks ahead of time for any who would help.