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

why not overloading -,=,_,\ operator

0 Answers

while installing jad file to mobile its giving processing attribute MDlet-jar-URL error...how to fix it

0 Answers

what things abutsbi

0 Answers State Bank Of India SBI,

Please if anybody have Vizag Steel Entrance exam papers or atleast Pattern of exam.Then please forward to my email- id: :srikanth.avanthi@gmail.com

0 Answers

difference between multi relational OLAP & multidimensional OLAP

1 Answers

i can access command prompt in my pc. when i type cmd in run,message comes-you are restricted.contact admin. why is it so? how can acces it by just logging in as a user and not as admin.?????

0 Answers

Why viruses wont affect Linux systems?

1 Answers

Hi, I am appearing for the ISRO exam for the post of Scientist/ Engineer to be held on 26th April,09. Can anyone help me regarding the same? I want to know about the exam pattern and the syllabus. If anyone could share your experience or sample papers for the same at khadhar786@rediffmail.com? It would be very useful for me. Thanks.

0 Answers

what are the examples of E-Based Applications?

1 Answers

What is diff b/w TON and BTU for Air conditioner?

0 Answers

what are the advantages as disadvantages of the V-model?

0 Answers

Can you connect Active Directory to other 3rd-party Directory Services? Name a few options.

0 Answers

For more Engineering AllOther Interview Questions Click Here