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?
There are prime factors of two numbers a and b , write a program using this prime factors whether a is divisible by b?
Give a brief description of the following terms: a) Play head b) Symbol c) Tweening d) ActionScript e) Frame rate f) Library panel g) Masking h) Context – sensitive Property Inspector i) Bandwidth Profiler j) Frame Label
funtionalities of loadining and linking
WRITE A C PROGRAM TO REVERSE THE LINK LIST WITHOUT CREATING NEW LIST?
What is histogram? why and how it is used?
Sir, I was recently placed at ITC Infotect. My ctc is 2.46lpa. How much will I get in hand every month? Plssss answer. Thanx in advance.
in which website , i can able to get the electrical basics.?????????????
hai im going to face ibps SO IT officers grade 1 interview. if anyone had an idea plz tel me expected and experienced questions and mail to anusha_k_anu@yahoo.com
what is disadvantages of waterfall model ?? industry used which model ??
How to Shut-down the system through QTP Script?
I am looking for NIC Scientific Officer / Engineer-SB (Programmer)Sample papers or any portion of questions/ syllabus plz, send me on sengupta.pranab@gmail.com. Regards PRANAB
how many clusters are generated by k-means algorithm?
why does the array will be start on size 0?
explain various object oriented programming fetures