Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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

Why we use 4 - 20 ma?

0 Answers  

How To Create RAID & Troubleshoot RAID related issue.

0 Answers   Omnitech,

What is different between analogous and digital

1 Answers   Microsoft,

I am some what lagging in talking English but i love to do job as an software engineer what will i do to improve my communication skills? please give me answer..........

1 Answers  

what do you mean by CPU register?

0 Answers  

hey frnds..i have taken an emergency interview date of 21st july and my school is starting from 8th sept...i was continuously checking the date from 10 days but was not able to get a normal can i get a rejection on this, that i have taken an emergency date.??????

0 Answers  

what is the advantage of msil in c#

0 Answers  

Problem:Design and implement a class that allows a teacher to track the grades in a single ourse.Include methods that calculate the average grae, the highest grade, and the lowest grade.Wrute a program to testyour class implementation in a c#. given grades:integral=85, physics=87, datastruct=84.

0 Answers  

Iam preparing for Visakhapatnam Management Trainee 2009 entrance exam.. If anybody have Visakhapatnam Management Trainee Interview questions Pls forward to my mail id .. It is kindly request..

0 Answers  

Write a program in ‘C’ that will accept 10 numbers from the user, sort them & then perform the binary search. The searching number will be arithmetic mean of the 10 numbers accepted from the user. Write the sort() & binSearch() functions for performing the sorting & binary search. Also create display function() for displaying the list. Sort() function will use selection sort and only receive one argument (Single char type)as type of sorting i.e. ascending (a) or descending (d). Display the list after sorting using a display() function. binSearch() function will accept one argument as a number to be search & return null or the index position of that number in the array. display() function is non argument non return type function. It will simply display the list row-wise. Program should use these functions by displaying the appropriate message for found or not found.

0 Answers  

what is advantages and disadvantages of vlan?

0 Answers  

How I can write a java program output the following 1+2+4+7+......N

0 Answers  

  • Civil Engineering Interview Questions Civil Engineering (5076)
  • Mechanical Engineering Interview Questions Mechanical Engineering (4445)
  • Electrical Engineering Interview Questions Electrical Engineering (16606)
  • Electronics Communications Interview Questions Electronics Communications (3915)
  • Chemical Engineering Interview Questions Chemical Engineering (1092)
  • Aeronautical Engineering Interview Questions Aeronautical Engineering (214)
  • Bio Engineering Interview Questions Bio Engineering (96)
  • Metallurgy Interview Questions Metallurgy (361)
  • Industrial Engineering Interview Questions Industrial Engineering (258)
  • Instrumentation Interview Questions Instrumentation (2992)
  • Automobile Engineering Interview Questions Automobile Engineering (332)
  • Mechatronics Engineering Interview Questions Mechatronics Engineering (97)
  • Marine Engineering Interview Questions Marine Engineering (123)
  • Power Plant Engineering Interview Questions Power Plant Engineering (172)
  • Textile Engineering Interview Questions Textile Engineering (575)
  • Production Engineering Interview Questions Production Engineering (0)
  • Satellite Systems Engineering Interview Questions Satellite Systems Engineering (106)
  • Engineering AllOther Interview Questions Engineering AllOther (1378)