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.
Answers
Answered by
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
Attachments:
Similar questions