Question

B) Consider the following Fabric table and write the
queries:
FabricID Fname
Type
Discount
F001
Shirt Wollen
10
F002
Suit
Cotton 20
F003 Jeans Denim | 10
F004 Shorts Cotton T5
(1) To insert a new record.
(2) To display those records whose type is
"Wollen".
(3) To modify the fabric shirt by increasing the
discount of 10
(4) To delete the record of fabric F003 from the
table.

Answer 1

(# .......= enter the values as per given in the question)not to be included in answer.

Answer 1.

>insert into Fabric values(...............);

Answer 2.

>select * from Fabric where Type="Woolen";

Answer 3.

>update Fabric set Discount= Discount+10 where Fname="Shirt";

Answer 4.

>delete from Fabric where FabricID="F003";

Mark as brainliest

Pleaseee!

All the best to all 10th classes for tomorrow I.T. Boards, I too have the same.