(iii) Write the statements to : (a) Insert a new row with appropriate data. (b) Increase the capacity of all the labs by 10 students which are on 'I' Floor.

Question

Accepted Answer

(a)
```sql
INSERT INTO LAB VALUES('L006', 'PHYSICS', 'RAVI', 25, 'II');
```

(b)
```sql
UPDATE LAB SET CAPACITY = CAPACITY + 10 WHERE FLOOR = 'I';
```

Question 34(3)

Answer

Explanation