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.
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
why unix commands simpler rather than complex task
Discuss about WAP architecture in detail.
Hi manikandhan, my name is ruby. Can u pls forward the conduct/character certificate on my Id. ruby_cse07@yahoo.co.in what details shall i require for this certificate. pls help me out with this..its really very urgent.. let me know soon bcoz my interview is on 19th septemper in mumbai...
what is the need for oobs
Can anyone send me iocl written test paper fro computer engineers
the conditional jump instruction in 8086 have a displacement of more than 1 byte.explain how would you tackle a situation in which it is required to branch,on some condition,to a location which is more than 120 bytes away.
Write a program in ‘C’ language that will perform the following operation on static stack. 1. push 2. pop 3. Display 4. Exit Create separate functions for each operation. The push() should accept one argument of structure type and will not return any thing. The pop() function will not receive any argument & return structure type value. The stack & top must be declare as external variable. Each element of stack will contain the following information Roll No, Std Name, Course. Use do-while loop & switch case for generating the above menu. The format of the output should is given below: S.No. Roll No. Student Name Course 1 cse01 Anil Singh B.Tech
how to implement spiral model on railway reservation?.
what is difference between class and object in c++
Iam preparing for Visakhapatnam Management Trainee 2009 entrance exam.. If anybody have Visakhapatnam Management Trainee Interview questions Pls forward to my mail id srikanth.avanthi@gmail.com .. It is kindly request..
what are purchase order , sales order idoc names and idoc types
How does C pass variables to a function ?
What is mean by the error LVALUE REQUIRED in C language
What is the instruction to load the register B?
how convert the spiral model to prototype model ?