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.



Automation of XYZ Soft drink parlour XYZ Soft drink Parlour wants to automate its functionalities..

Answer / 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

More Engineering AllOther Interview Questions

what is a structure in c language?

0 Answers  


i want questions only on code part like general logics in c and java

0 Answers  


What is Campus selection process of patni at Adcet,Ashta at 24th dec 2010.Also give apti syllabus.

0 Answers   Patni,


what are the main points to be included in our introduction when asked in hr...??

0 Answers  


what is the ans of prefix formula - + / 16 ^ 2 3 * 10 4 * 16 3

0 Answers  






what is the need to take testing as a carrier?

2 Answers  


what is the effect of low frequency(say 48Hz) on TUrbo- Generator set when running for a prolonged period?

0 Answers   Bhel,


Discuss the various process operations, clearly stating what is involved in each process operation.

0 Answers  


hi this santosh sharma i want to know more question of system engineer job related.

0 Answers  


what are the artifacts in coding phase in SDLC????

0 Answers  


series:1,4,2,8,6,24,22,88?

1 Answers   TCS,


I am having 17 months experience in development.I want to take testing as my career.I dont have experience in testing. Will get job anywhere?

0 Answers  


Categories
  • Civil Engineering Interview Questions Civil Engineering (5084)
  • Mechanical Engineering Interview Questions Mechanical Engineering (4451)
  • Electrical Engineering Interview Questions Electrical Engineering (16631)
  • Electronics Communications Interview Questions Electronics Communications (3918)
  • Chemical Engineering Interview Questions Chemical Engineering (1094)
  • Aeronautical Engineering Interview Questions Aeronautical Engineering (239)
  • Bio Engineering Interview Questions Bio Engineering (96)
  • Metallurgy Interview Questions Metallurgy (361)
  • Industrial Engineering Interview Questions Industrial Engineering (259)
  • Instrumentation Interview Questions Instrumentation (3014)
  • Automobile Engineering Interview Questions Automobile Engineering (332)
  • Mechatronics Engineering Interview Questions Mechatronics Engineering (97)
  • Marine Engineering Interview Questions Marine Engineering (124)
  • Power Plant Engineering Interview Questions Power Plant Engineering (172)
  • Textile Engineering Interview Questions Textile Engineering (575)
  • Production Engineering Interview Questions Production Engineering (25)
  • Satellite Systems Engineering Interview Questions Satellite Systems Engineering (106)
  • Engineering AllOther Interview Questions Engineering AllOther (1379)