Sample automated restaurant transactions case study:

• A waiter takes an order at a table,and then enters it online via one of the six terminal 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 sandwich or
• The bar printer if it is a drink
• A customer's meal check- listing (bill) the item ordered and the respective prices are automatically generated
• This ordering system eliminate 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 stock' message which will be displayed on the dining room terminal when waiters try to order that item

==> This gives the waiters faster feedback, enabling them to give better service to the customer's

• 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 helps management plan menus according to customers tastes

• The system also compares the weekly sales total 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 leter in management decesions, 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 systems available before one was chosen,

1. Enlist steps of a real time transactions system in your chosen/ allotted business domain ( involving customer's and 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?