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
- 3040 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 are the duties of QA/QC Coordinator
Can main() function can be made virtual?
HOW CAN YOU RELATE THE FUNCTION WITH STRUCTURE EXPLAIN WITH APPROPRIATE EXAMPLES
THERE iS ANY DEFAULT CONNECTION STRING FOR WINDOWS APPLICATION IN VB.NET2005 FROM WHICH AFTER CHANGING PROJECT DIRECTORY TO OTHER PLACE AND WE DID NOT CHANGE DATABASE PATH INB SQL CONNECTION ?????
I'm currently placed in Lahore Pakistan. where can i do Microsoft certification. let me know the best place to do.?
Tell me all about production of drought and its losses In the boiler?
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
WAP in Java to print the format: ABC BCD CDE EFG
If any kind of accident happen without any information to any one .what kind of action we have to take
An inversion is an array of numbers is any pair (i,j) such
that i
what are nanoemulsions and how are they prepared? i want a brief outline about nanoemulsions.. is anyone of you is having any literature, can you share that? also any an idea where i can get the information?
how to make resume and what should I include in it?
Box 1 cotain odd value X or Y the box 2 =X i.e 7 or 12 box 3= Y has value 19 if X is 7 or 31 if x is 12 get even value X or Y Use any operator steps allowed 3.
what is a query for divide a table into two subtable?
how can we implement the raid techmology on linux. operating system
