Question

Q. 21
a) The structure of a table "ITEM" is given below.
Suggest suitable data type and size of each column.
Column name
Type
Size
itemno
Iname
Price
Quantity
b) Consider the following table "ITEM":
Table: Item
Itemno
Iname
Price
11
Soap
40
22
Powder 80
Quantity
80
30
33
Face cream
250
25
44
Shampoo 120
100
55
Soap box
20
50
Write queries to
i. Display the total amount of each item. The amount must
be calculated as the price multiplied by quantity for
each item.
ii. Change the Quantity as 120 of Item name Soap

​

Answer 1

Answer:

1. Display the total amount of each item and the amount must be calculated as price multiplied by quantity for each item ..
2. And change quantity as 120 of item name soap.

Thank u hope its helpful..

Answer 2

ITEMS   Name            Price     Quantity       Total amount

no.  

11            Soap              40             80                   3200

22          Powder          80             30                   2400

33          Face cream   250           25                   6250

44          Shampoo       120           100                  12000

55          Soap box       20             50                   1000

Total                                                                        24,850.

• The total amount is 24,850.
• If we change the quantity of the item name 'soap' with price remaining same the total amount of soap will be 4800. The new total amount of all the item will be 26,450.
• Because the quantity of the soap increases the total amount increases from 24,850 to 26,450.
• In the old situation the highest quantity was of Shampoo' which was 100. In the new situation the highest quantity is 'soap' which is 120.
• The highest price in the given items is of 'face cream' which is 250 per unit.

#SPJ3