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.
Answer Posted / 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 View All Answers
what are the artifacts in coding phase in SDLC????
Hello friend I am Manish from delhi I clear the written exam of NIC(national insurance company),If any one have any idea about inerview plz send me details my no:-9999026117,Email id:-bittu523@yahoo.com
how to increase the chiller effiency?
what are the differences between one dimensional ram and two dimensional ram?
A polynomials in mamory can be represented by____________
i am astubent of BE3rd year currently in 6th semester branch information technology till now i have 73% near about in each semester the problem with me is that i have got only 58%in 12th class n 55%in 10th class bcoz of my health now i am ok i have got 2 year loss also bcoz i have not giveen the exam in class 12th rite now i am prep for GATE i am working hard pls tell will i get a good job in future in the good company bcoz my inter percent were not gud pls tell me help me pls
WRITE A C PROGRAM TO REVERSE THE LINK LIST WITHOUT CREATING NEW LIST?
Please derive the formula for the area of a circle.
whether we can implement VPN based on UDP? If yes then tell how? If no tell why not?
what is the formula/ ratio for hollow block? considering to a 40 kgs of portland cement.
what is the difference between verification and validation
What is frog testing? What is cone model?
can oracle driver be directly connected with odbc driver??
i am Ali from Hyderabad,having twice rejected on conference visa(USA),possessing 9 years of teaching experience,my current ielts score is 6 bands and my current age is 34,do suggest me some suitable universities for MBA course in USA,and what are the prospect of getting a visa.
Friends i want to know about the civil service examination...when it wil be conducted this year?i want to become DSP...I just completed my engineering in the stream of computers....Is percentage required in engineering to Write Mains?please help me send answers to my mail arun.kanduri@gmail.com