Henry Books;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;it would be wise to view my PowerPoint before doing the assignment. The grading rubric is attached.
Paper#65572 | Written in 18-Jul-2015Price : $87