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
3636 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

dam,rivers,states capt,

0 Answers

What is the importance of object oriented modeling in various approaches used in engineering

1 Answers

difference between java programming and c programming??

1 Answers

what are the things to be mentioned for the question "Tell me about yourself??

6 Answers CTS, Patni,

Please send us a brief description why do you think you can fit to the role

0 Answers npcc,

if all user defined constructor of a class made private,can we create an object of that class?justify your answer with an example.

2 Answers

What is the instruction to load the register B?

0 Answers

How to freely move a ball in graphics mode.

0 Answers Impetus,

what is far pointer?

0 Answers

Friends i want to know about the civil service examination...when it wil be conducted this year?i want to become DSP...I just completed my engineering in the stream of computers....Is percentage required in engineering to Write Mains?please help me send answers to my mail arun.kanduri@gmail.com

0 Answers

HI i have 2 year manual testing exp from MNC in pune but due to some reason i am looking job in testing . Friends hepl me to get the job i am not getting calls. alim24@gmail.com.09860643281

0 Answers

convert 140 N.m/cm^2 to N.m/mm^2

0 Answers

For more Engineering AllOther Interview Questions Click Here