TWOEG has a shop outlet that is managed with an inventory application. He has a list of vendors and all items they supplied stored in his database and he wants to:

1. Get a list of list of all vendors
2. Get a list of items owned by a vendor
3. Sort items in step 2 by quantity
4. Alert vendor by mail and Sms when stock quantity is low
5. Notify vendor by mail and Sms what items have sold.
6. Handle vendor payments.