Question

Very very urgent please answer it fast.​

Answer 1

a)Let the table name be FabricTable.

INSERT INTO FabricTable

[(FabricID< Fname, Type, Disc)]

Values

("F005","Kurta","Wollen",5);

b) Select * From 'FabricTable' where disc>10;

c)Select * from 'FabricTable' where Fname = woolen ;

d) Update fabric set disc= dics+ disc * 10/100 where fname="shirt" ;

e) Delete from 'FabricTable' where name is F003 ;

Answer 2

a. Insert into Fabric( "FabricID", "Fname", "Type", "Disc") values('F005', 'Kurta', 'Woolen', '5');

b. Select * from Fabric where Disc>10;

c. Select * from Fabric where Type='Woolen';

d. Update Fabric set Disc= Disc+10 where Fname= 'Shirt';

e. Delete from Fabric where FabricID= 'F003';

Hope it will help:)

I have a boards tomorrow too