Inventory Management System: The inventory management system has the process of inventory and monitoring products of Edwardsville Manufacturing Company (EMC). To monitor the process is cumbersome and time consuming. Additionally, the reports that needs to be submitted to different departments have discrepancies in them. So, an inventory management system needs to be created for the company. E-R Diagram requirements: EMC's products include bulldozers, graders, loaders, drilling rigs, and the like. All products have unique product identifiers, but they are also often referred to by product name. Other information includes availability (quantity available), description, price, category and other details. Customers are given unique id number to save their past orders. It should include name, address, email, contact number. A person from sales team is assigned to one customer. Orders are created by sales department including unique identifier, customer information, date of order and date of shipment, price, invoice number, quantity and discount. Payment information includes unique invoice number, customer id, amount and type of payment. Sales department is responsible for sales of products by calling the customers and offering deals and pricing. Each employee from sales department works on the commission and each order needs to include respective employee information. An employee information includes employee unique identifier, name, address, email and department. Finally, shipping details should contain composite key from order and customer table. Shipping should include shipment method, priority and shipment date.