Im trying to design ER diagram for Business.
This company uses GIN(Good Issue Note) and GRN(good receive note) to issue and receive stocks to branches all over country.
Company receives stocks by shipment from supplier in other country. Company transfer this stocks from port to main storage in order to distribute all over branches. When they issue stock from port they use GIN and at the main storage they use GRN.
Relationships i want to build is
1 ) Shipment stock issued to Store with GIN
2) Store Receive shipment stock with GRN.
I already have entities for GIN, GRN, Store and Shipment.
Please help me to understand how to build relationship as above 1 and 2/
Thank you in advance