A car manufacturer company purchases the items it needs for making cars – raw materials and finished car parts

A car manufacturer company purchases the items it needs for making cars – raw materials and finished car parts. Every purchasing transaction is documented in a purchasing order that the car manufacturer places with the appropriate suppliers. An order must have a date stamp, and it can list several purchasing items. Each item can be ordered in a needed quantity. For each purchasing item, the car manufacturer keeps evidence on the item name, list price, and specifications (for example, dimensions, colour, and material). The company also tracks its suppliers’ names, and addresses. Create a schema for the car manufacturer’s purchasing process. Do not forget primary keys and foreign keys. You do not have to specify the multiplicity