I'm trying to help my parents get out of the stone-age. My parents own a retail outerwear shop and they do everything the old fashioned way, by hand. I'm trying to set up a simple database to hold all their transactions so later they can doo lookups and A/R and A/P reports, etc, etc. First let me show you what I have so far:
I'm stuck in how to set up the products table. They have inventory plus they perform services, like remodeling, repairs, and storage. So I was wondering if I should set up 3 seperate databases, one for inventory, one for repairs/remodeling, and another for storage or just have one giant products table with storage being one row, repair/remodelling another row, and the inventory taking up the rest of the database. Before I go on, I was wondering if anyone had any experience with such a retail database and what they recommend and if there are any pitfalls I should lookout for. Any input would be much appreciated by this n00b database designer. Also if you recommend changing any of my current tables or will they do for now.