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
3807 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 difference between "type testing" and "product qualification"?

0 Answers

discuss the technique for implementing high performance computing

0 Answers

postfix expression for x^y^z-m+n+p/q ?

0 Answers Cognizant,

am a textile eng. frombut with major of my course including chemical eng, subjects, can i too apply to the co.?

0 Answers

what is the difference a zero argument constructor and a default constructor?

0 Answers

Proove it 3+4=5

2 Answers

i cannot go to my computer to set up why?

0 Answers

Write a nonrecursive routine to reverse a singly linked list in O(N) time.

4 Answers Aptech, College School Exams Tests, IIIT, Infosys, KL University, SRM,

what is isolator

0 Answers

Prepare the UGC CSIR net question papers those are enough. The question paper will be of 50 questions in size each 3 marks and with a negative of -1 for each wrong answer

0 Answers Ecil,

Explain the concept of segmentaion.

0 Answers

Meaning OF BRD SSD FSD TDD SRS FSR IN SDLC

1 Answers Infosys,

For more Engineering AllOther Interview Questions Click Here