Sample automated restaurant transaction case study:

• A waiter takes an order at a table ,and then enters it online via one of the six terminals located in the restaurant dining room
• The order is routed to a printer in the appropriate preparation area:
• The cold item printer if it is a salad
• The hot item printer if it is a hot sandwish or
• The bar printer if it is a drink
• A customers meal check-listing (bill) the items ordered and the respective price are automatically generated.
• This ordering system eliminates the old three-carbon-copy guest check system as well as any problems caused by a waiters handwriting
• When the kitchen runs out of a food item, the cooks send out an out of stocks message,which will be displayed on the dining room terminal when waiters try to order that them

==> this gives the waiters faster feedback,enabling them to give better service to the customer

• Other system features aid management in the planning and control of their restaurant business
• The system provides up-to-the minute information on the food items ordered and breaks out percentage showing sales of each item verus total sales

==>This help management plan menus according to customers tastes

• The system also compare the weekly sales totals verus food costs,allowing planning for tighter cost controls
• In addition, whenever an order is voided, the reasons for the void are keyed in
• This may help letter in management decisions, especially if the voids consistently related to food or service
• Acceptance of the system by the users is exceptionally high since the waiters and waitresses were involved in the selection and design process
• All potential users were asked to give their impressions and ideas about the various system available before one was chosen:

1. Enlist steps of a real time transaction system in your chosen/ alloted business domain( involving customers & management, both)?
2. What must a users guarantee with respect to a transaction and database consistency?what should a DBMS guarantee with respect to concurrent execution of several transactions and database consistency?