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

If a stored procedure is taking a table data type, how it looks?

0 Answers

What would happen if you drilled through the Earth all the way to the other side and then jumped into the hole?

0 Answers

what is difference between class and object in c++

0 Answers

why only j2me is used for mobile???

0 Answers

HI frds,,,am final yr IT student.. i secured 81% in x 55% in xii 87% in Btech upto last sem (no standing arrears..) i dt kw clearly abt MNC eligibility criteria.. i heard tat TCS hired 1y abv 60% 1y..so pls help me.. wic cmpnys r anouncd 55% may eligibl in 2011??? pls rly me clearly and sugst som of d compny names...

1 Answers

how to convert postfix notation into prefix in data structures. please send me algo of taha

0 Answers

Hi i'm richa piplani applied for ATC(IT) if u have the syllabus & old question papers forward me.I will be very much thankful to you. piplani.richa@gmail.com and sonu_pips@yahoo.co.in

0 Answers

four jobs j1,j2,j3 and j4 are waiting to be run. Their expected runtimes are 9,6,3 and 5 respectively. In order to minimize average response time, the jobs should be run in the order: a) j1j2j3j4 b)j4j3j2j1 c)j3j4j1j2 d)j3j4j2j1

2 Answers TCS, UGC NET,

what are the ores of copper, what is copper reserve of india

1 Answers Electrical, Hindustan Copper,

what is active dirctory?

2 Answers jetking,

Modal vs Modaless in VB??

0 Answers

Write a function that responds to a click anywhere on the page by displaying an alert dialog. Display the event name if the user held Shift during the mouse click. Display the element name that triggered the event if the user held Ctrl during the mouse click. (Answer in Java Language)

2 Answers Infosys,

For more Engineering AllOther Interview Questions Click Here