use SQL to complete the following exercises. 

1. Create a table named SALES_BRANCH.The table has the same structure as the BRANCH table shown in Figure 3-34 except the BRANCH_LOCATION column should use the VARCHAR data type and the BRANCH_NUM and NUM_EMPLOYEES columns should use

the NUMBER data type. Execute the command to describe the layout and characteristics of the SALES_BRANCH table. 

2. Add the following row to the SALES_BRANCH table: branch number: 5; branch name: Henry 

Town Plaza; branch location: 165 Plaza; and number of employees: 3. Display the contents of the SALES_BRANCH table. 

3. Delete the SALES_BRANCH table. 

4. Run the script file for the Henry Books database to create the six tables and add records to the tables. Be sure to select the file for the particular DBMS that you are using (Oracle, SQL Server, or Access). (Note: If you do not have the files for this text, ask your instructor for assistance.) 

5. Confirm that you have created the tables correctly by describing each table and comparing the results to Figure 3-34. 

6. Confirm that you have added all data correctly by viewing the data in each table and comparing the results to Figures 1-4 through 1-7 in Chapter 1. 

Please do the exercise for Henry Books on Page 91. In step #4, you are instructed to use a script file to build the tables - ignore this instruction. Instead, you will need to build the file yourself using the CREATE TABLE command. The Record layout information is on page 92-93. The records to be entered begin on page 9 

Please put all commands in one NOTEPAD file. Include a Screenshot of the results of the execution of any one the problems (one only will suffice) to illustrate your code. Id it is missing, the assignment will not be graded
Powered by