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
3656 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 does the 'divisibility by 3' rule work?

0 Answers

as a fresher what is the format for resume and suggest me some career objectives too........

0 Answers

Hi l, I want to install a water purifier (UV) at my home. the distance of water purifier from water tank [1000 lt ] is 7 ft. Is it sufficient for electrical water purifier? I want to know what is the water pressure from 1000 lt tank (the pipe used from water tank to machine is of inch 1-1/4") please note minimum water pressure is required for UV is - Water Pressure Min: 0.4 kg/sq. cm.Max: 2.0 kg/sq. cm. Please advise me on the following: 1) What is the water pressure generate in above condition. 2) What is the required height from the UV machine to water tank for the above condition? Thanks is advance.

0 Answers

the interviewer ask me If i accept to in lower position than the one i was tested for

2 Answers

Write a program in ‘C’ language that will perform the following operation on static stack. 1. push 2. pop 3. Display 4. Exit Create separate functions for each operation. The push() should accept one argument of structure type and will not return any thing. The pop() function will not receive any argument & return structure type value. The stack & top must be declare as external variable. Each element of stack will contain the following information Roll No, Std Name, Course. Use do-while loop & switch case for generating the above menu. The format of the output should is given below: S.No. Roll No. Student Name Course 1 cse01 Anil Singh B.Tech

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

Difference between strdup and strcpy in c language?

1 Answers

What is a computer without a hard disk called as technically ?

1 Answers

HELLO EVERYONE ON YAHOO , I'M IN NIGERIA AND I Will LIKE TO MOVE AND WORK IN CANADA , ANY SKILLED WORK IS OK BY ME AND THE PERSON WILL PAY THE BILL FOR IT, I WILL SERVE THE PERSON FOR THE EXPENSES.......... LOVE TO READ FROM YOU SOONEST AS YOU WISH TO HELP ME OUT

0 Answers

My gre score is 283 and ielts is 5.5, will i get i20 for this score

0 Answers

if your monitor is not started with your cpu, but start when monitor attach to another cpu then where is the problem?

2 Answers

How to write AM/FM demodulation in C language ?

0 Answers

For more Engineering AllOther Interview Questions Click Here