Automation of XYZ Soft drink parlour XYZ Soft drink Parlour wants to automate

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.

Question Posted / rahul bisht

1 Answers
3735 Views
I also Faced
E-Mail Answers

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 the differences between software engineering and other engineering disciplines.

0 Answers

how can i write a program in c of SPARCE MATRIX(data structure)?

0 Answers

what is recursion in c language?

0 Answers

the transfer of data from cpu to peripheral devices of a computer is achieved thru?

2 Answers iNautix,

can any one please tell me what is mean by back papers,back log,historical standing ????????? this mean history of arrears is it correct or not.........

0 Answers HCL,

2. A product selected for testing is equally likely to have been produced by one the 6 machines/processes. (i) Determine sample space ‘S’ (ii) What is the probability that the product is from machine 1? (iii) What is the probability that the product is from machine 2 or machine 4? (iv) What is the probability that the product is from both machine 5 and machine 3? (v) What is the probability that the product is not from machine 6? (vi) What is the probability that the product is not from either machine 6 or machine 1?

0 Answers

what is your experience in developing technical specifications?

0 Answers

discuss the technique for implementing high performance computing

0 Answers

What are saw filters used for?

1 Answers

a particle moving in a straight line with constant acceleration has a velocity of 8m/s at one instant and 3 seconds later it has a velocity of 2m/s.find its acceleration.

1 Answers

please provide me the type of questions or question pattern of bally.

0 Answers

main() { int arr[]={12,14,16,18,20} printf("%u%u";arr+1,&arr+1); } //tell me the answer of this question with proper reason..:)//

1 Answers

For more Engineering AllOther Interview Questions Click Here