This project is trying to design a small db for people to search for common info they need from procurement department. For example, as a importer in the supply chain, the company doesn't control production end, Yet, knowing the status of our open purchase order provides more flexibility on new customers/distributors order for not only domestic but direct import to other countries. Another example is the accounting specialist, he or she may want to know how many product left from vendor A, B and C, so he/she can arrange the priority of the payment.
Auto convert tool: https://erdplus.com/