Use SQL to make the following changes to the Henry Books database (Figures 1-4 through 1-7 in Chapter 1). After each change, execute an appropriate query to show that the change was made correctly. If directed to do so by your instructor, use the information provided with the Chapter 3 Exercises to print your output. For any exercises that use commands not supported by your version of SQL, write the command to accomplish the task. Write the commands to obtain the following information from the system catalog. Do not execute these commands unless your instructor asks you to do so. a. List every column in the PUBLISHER table and its associated data type. b. List every table that contains a column named PUBLISHER_CODE. c. List the table name, column name, and data type for the columns named BOOK_CODE, TITLE, and PRICE. Order the results by table name within column name. (That is, column name is the major sort key and table name is the minor sort key.)
Use SQL to make the following changes to the Henry Books database (Figures 1-4 through 1-7 in Chapter 1). After each change, execute an appropriate query to show that the change was made correctly. If directed to do so by your instructor, use the information provided with the Chapter 3 Exercises to print your output. For any exercises that use commands not supported by your version of SQL, write the command to accomplish the task.
Write the commands to obtain the following information from the system catalog. Do not execute these commands unless your instructor asks you to do so.
a. List every column in the PUBLISHER table and its associated data type.
b. List every table that contains a column named PUBLISHER_CODE.
c. List the table name, column name, and data type for the columns named BOOK_CODE, TITLE, and PRICE. Order the results by table name within column name. (That is, column name is the major sort key and table name is the minor sort key.)
Step by step
Solved in 2 steps
