Question

a) Create the following table Food_Items.

Column name Data type Size Constraint

ItemNo Numeric 3 Primary key

Iname Character 15

Price Numeric 10,2

Quantity_per_plate Numeric 3

b) Consider the following table Food_Items and write the queries (i) and (ii).



ItemNo IName Price Quantity_per_item

1 Dosa Sambhar 250 10

2 Pav Bhaji 2140 30

3 Chole Bhature 150 25

4 Paani Puri 105 15

5 Chaat 50 10

i. Write a command to insert a new record with the following values

(6 , ‘Chowmein’ , 160 , 6 )

ii. Write a query to display all the records of table whose prizes 125 or more.

OR

Write a query to display all the records in the table in descending order of

quantity_per_plate. 4 mark​

Answer 1

it is nothing ahhahahahahhahahahaahah

Answer 2

Answer:

(a) Create the following table Household items'

141

l4l

l4l

l4l

l4l

(b) Consider the following table Item and write

Table: Household Items

Column name

Itemno

Iname

Price

Quantity per item

ltemno

I

2

J

4

5

Data type

Integer

Varchar

Numeric

lnteger

Iname Price

Bedsheet 800

Bed cover 620

Blanket

Carpet

Pillow cover

Size Constraint

Primary keY

15

10,2

J

the queries (i) and (ii).

1800

900

50

Quantity per item

100

310

225

15

10

(i) Write a command to insert a new record with the following values : (6, T.V Covel 150, 20)'

(ii) Write a query to display all the records of table Item whose price is more than 500.

OR

Write a query to update the Price of ltemno: 5 as '75''