Interested to Buy Any Domain ? << Click Here >> for more details...
Automation of XYZ Soft drink parlour
XYZ Soft drink Parlour wants to automate its functionalities.
The Admin can add new items in the stock and also update the
details of the
existing items. The items are only soft drinks .The details
to be maintained
are Item’s name, quantity and price.
The salesman can view the availability of the items as per
the order placed
then confirms the order.
At the end of day the Admin generates a report of the total
sales (total
quantity and price of individual items).
Identify the Joins , union, and Cartesian product Report.
- 1 Answers
- 3806 Views
- I also Faced
- E-Mail Answers
Answer Posted / rahul bisht
there are 4 tables , salesman , item , order, item details,
salesman-itm :1to many
order-Item:many to many
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
what is 16 bit processor and what is 32 bit processor?how can we differentiate and identify or find that ?How they access data?
how will u recieve an std idoc from sendor->reciever
What are the fundamental differences between Engineering and Physics?
Why the secondary ip address of interface is not advertising in IGP cloud?
How to write test cases for Auditing in Health care Applications?
pls send me rrb se(s&t)questions
Explain how to share outlook calenders and the type of permissions you need to assign?
A company canteen needs an automated system for its food and beverage management. The canteen receives food and beverage items from different distributors. All the non perishable items are stored in the store-room and the perishable items are put in the fridge. The manager should be able to add, delete or update food and beverage items onto the system and perishable and non perishable item details are to be stored separately. Both waiters and the cooks should be able to update the perishable items, but only the cooks should be allowed to update the non perishable items. Both cooks and waiters are not allowed to add or delete any items that are entered. identify the Schema, Table , Fields
Hello, I need to compare, using a cobol program, two cobol skeletons. I don't know if it is easy to do this or it will be so complicated. I wanna have your opinions. Thanks a lot
Friends Any one tell me the best institute for the telecom protocol course
I an doing Engineering in IT(4th year). i want to know what is the scope or .NET and Linux, and which is better for carrier
pls send me the e-book for verbal and non verbal reasoning of R S aggarwall
how do we calculate physical address if logical address is given in the question?
need tcs questn papers from 2007 to 2009 plzzzmail to 9015.rama@gmail.com its urgent
hi,i just want to know the best institute to learn oracle in bangalore because i am doing my BE there?
