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
3805 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 saturation point?

1 Answers

i need to know abt renault nissan company and the rounds and type of questions asked by today

0 Answers

what is the difference betweeen far pointer and near pointer

0 Answers

What is IPSec?

0 Answers HCL,

how do we get persistent databases?

0 Answers

Describe an impedance matching circuit?

2 Answers

describe how your code can determine if the user entered an input box value or click the cancel button?

0 Answers

where are the auto variables stored in c language?

1 Answers

What is the main difference between binary and counting semaphore?

0 Answers

I am looking for NIC Scientific Officer / Engineer-SB (Programmer)Sample papers or any portion of questions/ syllabus plz, send me on sengupta.pranab@gmail.com. Regards PRANAB

0 Answers

Briefly describe an experience of yours that illustrates your ability to clearly articulate and explain technical issues in a nontechnical manner

0 Answers

successful command to make linux system as router in redhat-+

0 Answers

For more Engineering AllOther Interview Questions Click Here