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
- 3023 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
hi , anyone plz end nic model papers to my id
Is there any difference between the concepts of encoding,decoding and encryption and decryption?
how the aeroplane protected from the lightening?
What is the difference between "type testing" and "product qualification"?
I want old SBI question papers plzzzzzzzzz
is the meter head is same as back pressure?
hai,am a marine engineer..pls anyone tell me what is the abbrevation for "gfca" in Mitsui B&w 7l67gfca engine.my mail id is kamaraj_mech@yahoo.co.in
I am haning thousands emails in my send box (which i sended.) Now i want to send all these emails (Total in send box)to other by email. Can i send total emails at one time (Not sending each indivisually) by one comand; Please tell the steps..Thanks.
why this for loop doesn't work .
int i;
for(i=2;i=0;i--)
{
cout< a steel bar 1' inch square 6' long is to be used as a
column.ends are free to rotate put may not be
displaced.stress is limited to 30,000 PSI HOW CAN YOU RELATE THE FUNCTION WITH STRUCTURE EXPLAIN WITH
APPROPRIATE EXAMPLES why every computer should have a boot strap routine? draw diagram of earthings How many codes are used when u design a Pressure Vessel why u r shifting from engineering to other field ?
