1. Summarize the functionality of the SQL alter table statement discussed in this chapter.
2. The following questions provide practice in using the most basic form of the select statement, where data from all the rows in the table are included in the result set. All solutions have the same basic structure – an instruction to the DBMS to ‘SELECT the data in these columns FROM this table’. There are no where clauses needed in any of the select statements for this question.
(a) Write an SQL statement to display the data in the assetNo and assetType columns from all rows of the Equipment table. Do not display data from the other columns.
(b) Write an SQL statement to display the data in the assetNo, assetType and description columns from all rows of the Equipment table. Do not display data from the other columns.
(c) Write two different SQL statements to display the data in the building, roomNo and capacity columns from all rows of the Room table. One statement should use column names and one not.
(d) Display the data in the building and room columns from all rows of the Equipment table. Ensure that if two rows have the same data in the building and room columns, then that data is shown only once.
(e) Display the data in the building and roomNo columns from all rows of the Room table. Again, ensure that if two rows have the same data in the building and roomNo columns, then that data is shown only once.