I need help developing a Entity Relationship Diagram ERD based on the information below. I attached a photo of the business process that is suppose to be figure 2. Please help!! I am so confused on how to start or even get this done.
The business process of JC is largely composed of four parts: 1) procurement; 2) production; 3) sales; and 4) various types of report or information retrieval for business analysis. JCs procurement process includes activities regarding procurement of computer parts from suppliers. Production process includes the activities assembling parts into PCs in its factory using limited production capacity. In the sales process, JC has to bid on the offers coming from business customers to win orders. Details of the process are as below.
Figure 2. JC's business process
A transaction of sales order begins with sales RFQs (Request for Quote) from customers to JC and other PC companies. JC then submit a sales offer with a bidding price to win the order, and customers choose the bid with the lowest price. To assemble PCs, agents need to procurement computer components from suppliers. When an agent wants to purchase a component, it issues a procure RFQ to multiple suppliers. Each supplier then decides the price and quantity and sends the procurement offers to the companies. As a final step, JC sends procurement orders to suppliers if they want to purchase the product as offered in the procurement offer. Then the components are delivered on the due date and these components can be used on the next day of the delivery. These delivered components are stored in components storage. Every day the cost of components in storage is charged until they are removed for production.
After receiving the components, JC assembles PCs to fulfill the customers orders. JC needs to therefore establish plans for production and shipment. The factory assembles PCs as planned in the production schedule using component inventory and factory capacity within the boundaries of available resources. Finished PCs are shifted into product storage on the same day. Once PCs are stored in storage, these products are shipped to the customer according to the shipping schedule to satisfy customer orders. Unlike component delivery, the delivery for PCs should meet the entire amount in sales RFQs. If it is not met, the agent is charged for late delivery. This is the sales penalty.
This is one cycle of required work to complete a customer order. However, customer orders arrive every day with various due dates between three and twelve days after the current day even if the previous orders have not been completed. Figure 2 is the depiction of the cycle of sales order and procurement process.
In these business processes, JC wants to store ALL of the information, e.g., procurement and sales RFQs, sales offers, procurement prices, winning sales prices, factory resource log, daily inventory level, production plan, shipping plan, and etc, for future business analysis. JC will have a meeting to talk about the details of the processes if database designers want since this document just reveals the outline of JCs business processes and related requirements.
Supplier Supplier Supplier Supplier Procure Order Component Delivery Delivery Schedule Procure RFC Procure Offer Production Schedule Production / Produced PCS Inventory Factory JC Inventory Factory JC Inventory Factory JC Inventory Factory JC Sales RFO Sales Order Sales Offer Product Delivery Customer Customer Customer Customer +0 D+1 D+2 D+3