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
What is the strongest naturally occurring material and how can it be cut?
What a test plan contains
what is the working of tcp/ip?
how i run the assembly language code
What is the pressure in co2 cartridge in a DCP 5 kg extinguisher.
computer is male or female.....???
What is Mointer in Operating System?
How to Define the defect density?
what is rapid application development
boolean isBadBoy(boolean hasGirlFriend , boolean isMarried, int age , String middleName , String lastName , String[] brotherName);
System Not Getting Shut down Through Software Auttomatically It Will Restart wat is the Problem?
write a program for reverse a given string?
i am Ali from Hyderabad,having twice rejected on conference visa(USA),possessing 9 years of teaching experience,my current ielts score is 6 bands and my current age is 34,do suggest me some suitable universities for MBA course in USA,and what are the prospect of getting a visa.
WHY WE SELECT U AS A PERTOLEUM ENGINEER THOUGH UR MARKS ARE LESS THEN OTHER APPLICANTS
please provide me the type of questions or question pattern of bally.