Here I have uploaded the inventory database example. I am needing help on how to write some of the scripts. Using SSMS.

CoursHeroTranscribedText

Transcribed Image Text:

CREATE TABLE REP (REP_NUM CHAR (2) PRIMARY KEY, LAST NAME CHAR(15), FIRST NAME CHAR (15), STREET CHAR(15), CITY CHAR(15), STATE CHAR(2), POSTAL CODE CHAR(5), COMMISSION DECIMAL (7,2), RATE DECIMAL (3,2)); CREATE TABLE CUSTOMER (CUSTOMER_NUM CHAR (3) PRIMARY KEY, CUSTOMER_NAME CHAR(35) NOT NULL, STREET CHAR (20), CITY CHAR(15), STATE CHAR(2), POSTAL CODE CHAR(5), BALANCE DECIMAL (8,2), CREDIT_LIMIT DECIMAL (8,2), REP_NUM CHAR(2) ); CREATE TABLE ORDERS (ORDER_NUM CHAR(5) PRIMARY KEY, ORDER_DATE DATE, CUSTOMER_NUM CHAR(3) ); CREATE TABLE ITEM (ITEM_NUM CHAR(4) PRIMARY KEY, DESCRIPTION CHAR(30), ON_HAND DECIMAL (4,0), CATEGORY CHAR(3), STOREHOUSE CHAR(1), PRICE DECIMAL (6,2)); CREATE TABLE ORDER_LINE (ORDER_NUM CHAR (5), ITEM_NUM CHAR(4), NUM_ORDERED DECIMAL (3,0), QUOTED_PRICE DECIMAL (6,2), PRIMARY KEY (ORDER_NUM, ITEM_NUM)); INSERT INTO REP VALUES CREATE TABLE REP (REP_NUM CHAR (2) PRIMARY KEY, LAST NAME CHAR(15), FIRST NAME CHAR (15), STREET CHAR(15), CITY CHAR(15), STATE CHAR(2), POSTAL CODE CHAR(5), COMMISSION DECIMAL (7,2), RATE DECIMAL (3,2)); CREATE TABLE CUSTOMER (CUSTOMER_NUM CHAR (3) PRIMARY KEY, CUSTOMER_NAME CHAR(35) NOT NULL, STREET CHAR (20), CITY CHAR(15), STATE CHAR(2), POSTAL CODE CHAR(5), BALANCE DECIMAL (8,2), CREDIT_LIMIT DECIMAL (8,2), REP_NUM CHAR(2) ); CREATE TABLE ORDERS (ORDER_NUM CHAR(5) PRIMARY KEY, ORDER_DATE DATE, CUSTOMER_NUM CHAR(3) ); CREATE TABLE ITEM (ITEM_NUM CHAR(4) PRIMARY KEY, DESCRIPTION CHAR(30), ON_HAND DECIMAL (4,0), CATEGORY CHAR(3), STOREHOUSE CHAR(1), PRICE DECIMAL (6,2)); CREATE TABLE ORDER_LINE (ORDER_NUM CHAR (5), ITEM_NUM CHAR(4), NUM_ORDERED DECIMAL (3,0), QUOTED_PRICE DECIMAL (6,2), PRIMARY KEY (ORDER_NUM, ITEM_NUM)); INSERT INTO REP VALUES