I need help creating a data base for a commodity trading company
Vendors sell a product;
Product is loaded in a container;
Container is provided by a freight forwarder;
Payment to the Vendor is sent when the container is loaded.
This is pipeline inventory until it is sold to a customer.
Customer buys a product,
Customer has a final destination for the product. This destination can keep changing with each shipment. So one customer can have multiple destinations.
Product has images, description, origin, and other details.
Above was a scenario for international purchase and sale.
Here is a scenario for a local purchase and sale.
Vendor supplies product,
upon approval, product is loaded
material is then directly sold
If not, it is sent to one of our 2 facilities, or is unloaded there
Then it is sold to local customers at retail prices in unit qty.
I cant figure out where to start such a database. Please guide me. I dont want someone to do this for me but I need some expert help.