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 do you mean by static routing and dynamic routing?
can we specify variable field width in a scanf() format string? if possible how in c language?
what's the difference between windows serevr 2003 or windows XP.
What is the actual procedure of charging synthetic oil if the machine is under positive refrigerant pressure.
i need to know abt renault nissan company and the rounds and type of questions asked by today
What is the strongest naturally occurring material and how can it be cut?
What are the duties of QA/QC Coordinator
Differentiate y = sinx + cosx + tanx
nohup sort employees > list 2 > error out & what will happen?
How does Earthquake-proofing work?
How Good is tata nano?
PLC Training in chennai ? Best PLC Training center in chennai?
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)