Question

Write the SQL commands to answer the queries based on Fabric table ?


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) Which column of the table Fabric can be the primary key



b) To insert the following record : (‘F005’, ‘Kurta’, ‘Wollen’,5)



c) To modify the fabric shirt by changing discount to 15



d) To delete the record of fabric
F003 from table.


​

Answer 1

Answer:

Explancvxcvxcgfffffffffffffffffffffffffffffffffffffffffffffffffffffcation:

2. Investigate the conditions required for seeds to germinate. Set up your Explain your observations.

Soaked peas/seed,   Soaked peas/seed,     Soaked peas/seed, (5 marks)

Dry cotton wool     Wet cotton wool     Covered with water