a. Considering Figure 8-3, describe the tasks that need to be accomplished to change the name of the table WORK to WORK_VERSION2.
![816_fd8d1289-dd10-435e-845f-ab979373a091.png](https://secure.tutorsglobe.com/CMSImages/816_fd8d1289-dd10-435e-845f-ab979373a091.png)
b. Explain how views can simplify the process of changing a table name.
c. Under what conditions is the following SQL statement valid?
![556_222d5eea-493f-46f6-a9a2-9c591a316208.png](https://secure.tutorsglobe.com/CMSImages/556_222d5eea-493f-46f6-a9a2-9c591a316208.png)
d. Show an SQL statement to add an integer column C1 to the table T2. Assume that C1 is NULL.
e. Extend your answer to Review Question 8.29 to add C1 when C1 is to be NOT NULL.