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

Given a number (N), program to check whether its binary form has periodic or not

0 Answers

pls i need a help from you friends, is there anybody who can help me out with the question been ask from the USA embassy. i will be going for interview next month pls help me

0 Answers

5. Can you work well under deadlines or pressure?

0 Answers

hi all I got two exam call letter one from maha ganeco & other from federal bank both at same time & same date which should i choose (note I am eng. grad.)

0 Answers Federal Bank,

I am an Electrical engineering ( electrical back round ) ,can i get hvac Water system design details to easy understand ,i am working past 15years in Pharmaceuticals company with Engineering depart.

0 Answers Archimedis Healthcare,

Why do you want to work here

0 Answers FLSmidth,

what is your weaknesses

0 Answers Genco, TCS,

URGENT.. I want to make a really good project using ADVANCE JAVA Can anyone suggest any great n innovative ideas I have nearly 4 months to make it so it can be big n time consuming... It should be Web Based also... It can use more than one Java Technologies.. Please suggest me something innovative n great.. thanks:

1 Answers

what in 4th and 5th normal form ??

0 Answers

What is the allowable load carrying capacity of a circular column section of 400 mm diameter reinforced with 6x25 mm diameter bars adequately tied with spirals? Consider concrete of grade M25 and steel of grade Fe 415.

0 Answers

1)How to calculate AC Capacity for the Room?

0 Answers

what is test initiation?can anybody post the answer urgently?

0 Answers

For more Engineering AllOther Interview Questions Click Here