Have the following Task and i don't know how to deal with:
- Orders
- Customers
- Shipments
- Warehouses
The requirements are:
- Every Order includes different products and have only one customer
- Every Customer can have more than one address and it can be Individual person or Company
- Shipments should have Ship From and Ship to address but they can be divided by different 'Legs' Example: one shipment is going from A to B but it has to stop on C on the way so Two Legs.
- Each shipment consists of products that may be from different orders and for different customers
- some supplies may be partially or fully returned by customers. Returned products and the reason for return must be recorded.
any suggestion :(
