Question

ONLY ODD NUMBERS. YOU MUST USE ORACLE OR MY SQL.

THANKS

Chapter 3 TAL Distributors Use SQL to complete the following exercises 1. Create a table named SALES_ REP. The table has the same structure as the REP table shown in Figure 3-11 except the LAST_NAME column should use the VARCHAR data type and the COMMISSION and RATE columns should use the NUMBER data type. Execute the command to describe the layout and characteristics of the SALES_REP table. Add the following row to the SALES_REP table: rep number: 35, last name: Lim; first name: Louise; street: 535 Vincent Dr.; city: Grove; state: CA; postal code: 90092; com- mission: 0.00; and rate: 0.05. Display the contents of the SALES_REP table. 0 2. 3. Delete the SALES REP table 4. Run the script file for the TAL Distributors database to create the five tables and add records to the tables. Be sure to select the script file for the particular DBMS that you are using (Oracle, SQL Server, or Access). (Note: If you do not have the script files for this text, ask your instructor for assistance.) Confirm that you have created the tables correctly by describing each table and compar ing the results to Figures 3-11, 3-30, 3-32, 3-34, and 3-36 Confirm that you have added all data correctly by viewing the data in each table and comparing the results to Figure 2-1 in Chapter 2. Review the data for the ITEM table in Figure 2-1 in Chapter 2 and then review the data types used to create the ITEM table in Figure 3-34. Suggest alternate data types for the DESCRIPTION, ON HAND, and STOREHOUSE fields and explain your recommendations. 5. 6. C RITICAL7. THINKING

Answer 1

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

This demonstration is using Oracle.

1.Table Name :SALES_REP

SQL Script :

create table SALES_REP(
SALESREP_NUM char(2) Primary key,
LAST_NAME varchar(20) ,
FIRST_NAME char(15),
STREET CHAR(15) ,
CITY CHAR(15),
STATE CHAR(2),
POSTAL_CODE char(5),
COMISSION number(7,2),
RATE number(3,2)
);

Screen in Oracle :

null

Question 2 :

SQL Script :

Insert into SALES_REP values
(35,'Lim','Louise','535 Vincent Dr','Grove','CA','90092',0.00,0.05);

Screen in Oracle :

select * from SALES_REP;

Question 3 :

SQL Script :

drop table SALES_REP;

Screen in Oracle :

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.