Hi everyone,
We have 2 stores containing different items. Multiple items can be found in different stores but with different quantities. Attached is excel file for the stores items.
I need to make the following scenario.
Every employee can ask for multiple orders to departments from the stores
Each order contains multiple items
each item can belong to different stores
each store contains many items
each store can have the same items but with different quantities
I am completely missed up. I don't know how to manage the similar items in different stores with different quantities in each store.
Please help me to put the first design of the table relationship.
I don't know how to set table relationship between stores, items, employees, and even if wee have have supplier tables.