Question

Write the s ql to answer the quarit's based on fabric table
Fabric name type disc

Answer 1

the SQL commands to the queries based on the fabric table:

FabID Fname. Type. Disc

F01. SHIRT. WOOLEN. 10

F02. SUIT. COTTON. 20

F03. TUNIC. COTTON. 10

F04. JEANS. DENIM. 5

a) to insert the following record ("F005" , "kurta" , " woolen,5)

b) to display only those fabric who disc is more than 10.

c) to display those record whose type is " woolen".

d) to modify the fabric shirt by increasing the discount of 10.

e) delete the record of fabric F003 from table.