30. Write the SQL commands to answer the queries based on Fabric table
FabricID Fname Type Disc
F001 Shirt Wollen 10
F002 Suit Cotton 20
F003 Tunic Cotton 10
F004 Jeans Denim 5
F006 Shorts Cotton 7
a) To insert the following record
(“F005”, “Kurta”, “Wollen”,5)
b) To display only those fabric whose disc is more than 10
c) To display those record whose type is “Wollen”
d) To modify the fabric shirt by increasing discount of 10
e) To delete the record of fabric F003 from table
Answers
SQL commands:-a) insert ……. fabric values ("F005", "Kurta", " woollen" ,5 );b) select …..fname from fabric in case of disc>10;c) select * from fabric in cases ……where type ="woollen" ;d) updating of fabric set disc= dics+ disc * 10/100 where fname="shirt" ;e) delete from all the cases of fabric where fabid=F03 ;SQL, Structured Query Language is a domain-specific language applied in programming and designing for data management in an either in the relational database system,RDBMS or for stream processing in the management of relational data stream system, RDSMS.
It is particularly helpful in the handling of structured data where a relationship exists between different entities and variables of the data. SQL possess two main advantages over older reading and writing of APIs like ISAM or VSAM.