A Technology production specialist wants to implement a system to keep track of its products & orders: Software Architecture Assignment, TUD, Ireland

A Technology production specialist wants to implement a system to keep track of its products & orders. An internal IT enthusiast in the finance department has created a system to help with the sale pricing of products produced. The current system has 3 tables: Product, RawMaterial and
ProductRawMaterial. Currently, these tables are manually updated. We would like to integrate this system into the new system to add the required functionality

The required functionality is as follows:

• Add, view, edit and archive raw materials.
• Add, view, edit, and archive products.
• Add, view, edit, and close orders.

1. When orders are placed they are in an open state.
2. Orders may include 1 or more products.
3. Multiple items of the same product may be ordered.
4. Order item lines must be checked to see if products are in stock and marked as such.
5. When an order is closed the products (& raw material) must be removed from the inventory.
6. When an order is closed it can no longer be edited.
7. Orders cannot be closed unless all products are in stock.