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 / 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 |
What are the fundamental differences between Engineering and Physics?
How we calculate the recovery of steam as per coal in a boiler if we know the calorific value of coal?
what is the differences between DTD's and XML schema?
one fuse has following data 80A 415V -6.9W HN SIZE 00 100 KA gG Please tell me about what is the mean of 100kA gG
I want old SBI question papers plzzzzzzzzz
plz plz help me "how can i face dell varcent round"....? plzzzzzzzz help me friends.....?
Can you connect Active Directory to other 3rd-party Directory Services? Name a few options.
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.
What do u mean constructor in java ?
charak was the famous court physician of?
Hi i was appered the ISRO written test conducted on 26-Apr- 2009. I want to know the date of results. Please anyone tell me the date
How to score well in examination of MCA(engg) december 2012? please reply soon........
Civil Engineering (5086)
Mechanical Engineering (4456)
Electrical Engineering (16639)
Electronics Communications (3918)
Chemical Engineering (1095)
Aeronautical Engineering (239)
Bio Engineering (96)
Metallurgy (361)
Industrial Engineering (259)
Instrumentation (3014)
Automobile Engineering (332)
Mechatronics Engineering (97)
Marine Engineering (124)
Power Plant Engineering (172)
Textile Engineering (575)
Production Engineering (25)
Satellite Systems Engineering (106)
Engineering AllOther (1379)