Plz help me set up my database. Conditional value lists, invoice,line items and more.
I am attempting to create a database which seems complex to me. I have struggled for 3 days now . I want to make a database which tracks store products, and their weekly price changes. I also want to be able to simulate buying the products. Based on the research I have done this is what I think I need.
Profile - User can create a profile (easy I can do this)
Shopping Cart (invoice) - Will use to simulate buying products.
Sales prices - store and update product price changes
I would like for the products to have conditional value lists like this:
Store---> Item type---> Item type2---> Product
if someone could plz help me plan this out i would be so grateful.