Q) A manufacturing organization wishes to build a system to manage its inventory and sales processes. Ithas a number of products that it sells. It maintains an inventory of each product. Each product issupplied by a number of vendors. It is necessary to record the orders for each part and to relate these toeach customera) Draw a conceptual data model (e.g., UML or Entity-Relationship Diagram)b) Design a relational database in 3NF