A manufacturing organization wishes to build a system to manage its inventory and sales processes. It has a number of products that it sells. It maintains an inventory of each product. Each product is supplied by a number of vendors. It is necessary to record the orders for each part and to relate these to each customer. We also need to record the Purchase orders sent to each vendor.

(a) Draw a conceptual data model Using Visio (Entity Relationship Diagram).

(b) Design a relational database in 3NF.