What I would like is a software for a restaurant.
It should be composed of 2 parts: one that should be installed on waiters' PDAs to help them select the order and another one to be installed on an admin computer (the one on the PDAs should communicate through wireless with the one on the computer).
The one on the PDA is meant to help waiteres take the orders. The waiter should select from bunch of categories (a top down list with items for each category). I would want the waiter to be alerted if a particular item is not in stock. After the waiter completes the order, the data should be transmitted to the central computer. Also, if a client decides to add something to his order after the initial order has been processed the software should let him do it.
Also after the waiter brings some items from the order he sholud be able to check the items ( each item should have a check box that will be checked after the waiter brings the product ) as served on his PDA, thus helping him not to mix the orders.
The software on the central computer should remember the orders for each table and compute the total amount to be payed (and send it to the PDA). The database with the total stock should have the posibility to be changed whenerver the stock administrator wants (when the restaurant receives merchandise). Also, when a waiter adds an order, the products specified on the order should be substracted from the total stock.
A similar application you can see here:
[url removed, login to view]
Extremly important: I need the application for an university assignment, so I need the code and the database structure.
My budget is around 50$.