This question gives you some practice in modifying the table instance. In each case, write an appropriate SQL DML statement to complete the task.
(a) Add the following row of data to the Room table:
building = ‘Priestley’, roomNo = ‘114’ and capacity = 40.
(b) Add the following row of data to the Equipment table:
assetNo = ‘3124657’, assetType = ‘OHP’, description = ‘3M OHP 2000’, portable = FALSE.
Leave the remaining columns null. Why doesn’t the foreign key constraint prevent this row, which does not match any row on the Room table, being added?
(c) Now set the building and room for the piece of equipment added in part (b) to Priestley 114
(d) Increase the capacity of every room by 5.
(e) The Priestley building has burnt down, destroying all the equipment stored there. The insurance claim has been paid and a new building is under construction. Remove all data associated with this building from the Web Timetable database.