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
3706 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 the fallacy in the following program segment ? int *f1() { int a=5; return &a; } f() int *b=f1() int c=*b; }

1 Answers Geometric Software,

When a new build comes what is the first step taken by a tester in testing

1 Answers Sonata,

How I can write a java program output the following 1+2+4+7+......N

0 Answers

21. Find d Odd one out? a. LINUX b. WINDOWS 98 c. SOLARIS d. SMTP b. JAVA b. LISP c. Small talk d. Eiffel c. HTTP b. ARP c. SMTP d. SAP d. Linux b.windows NT c. SQL server d. UNIX e. SAP b. ARP c. WAP d.TCP IP f. Oracle b. Linux c. Ingress d. DB2 g. SMTP b. WAP c. SAP d. ARP h. WAP b. HTTP c. BAAN d. ARP i. SQL b. DB2 c. SYBASE d. HTTP

3 Answers TCS, Tech Mahindra,

What is CRC? the material will be used in electrical stampings.

0 Answers

What is your Job Profile in IT feild.

0 Answers

plz snd me sbi probationofficers papers to my id archpa@gmail.com

0 Answers

SIR i hv compleated b.tech(computer science engineering) with 82% marks. i want to join shipping corporation of india. it's my career dream. please i am eleasible or not?

3 Answers Shipping Corporation of India,

what is the channel capacity of a band-limited gaussian channel? is it is blog2(1+s/n) or not? if not what?

3 Answers UGC NET,

searching a B-tree indexed tree compared to B+ tree is slow..True or false

0 Answers NIC,

how to generate linked implementation of sparse matrix?

0 Answers

when does the official confirmation or the offer letter for the 2012 selected candidates of HUAWEI will come??

0 Answers

For more Engineering AllOther Interview Questions Click Here