1. SQL Script:

CREATE TABLE CUSTOMERs
( "CUST_ID" VARCHAR2(20) NOT NULL,
"FIRST_NAME" VARCHAR2(20) NOT NULL,
"LAST_NAME" VARCHAR2(20) NOT NULL,
"MI_NAME" VARCHAR2(20),
"STREET" VARCHAR2(20) NOT NULL,
"CITY" VARCHAR2(20) NOT NULL,
"STATE" VARCHAR2(20) NOT NULL,
"ZIP" VARCHAR2(20) NOT NULL,
CONSTRAINT CUSTOMER_PK PRIMARY KEY
(
CUST_ID
)
);

------------------

CREATE TABLE VEHICLES
(
VIN VARCHAR2(20) NOT NULL
, TYPE VARCHAR2(30) NOT NULL
, MODEL VARCHAR2(60) NOT NULL
, MAKE VARCHAR2(60) NOT NULL
, WHEREFROM VARCHAR2(30) NOT NULL
, WHOLESALE_COST DECIMAL NOT NULL
, TRADE_ID VARCHAR2(20) NOT NULL
, CONSTRAINT VEHICLES_PK PRIMARY KEY
(
VIN
)
);

ALTER TABLE VEHICLES
ADD CONSTRAINT VEHICLES_CHK_COST CHECK
(WHOLESALE_COST >= 0);

ALTER TABLE VEHICLES
ADD CONSTRAINT VEHICLES_UK1 UNIQUE
(
TRADE_ID
);

----------------------

CREATE TABLE SALES
(
SALE_ID VARCHAR2(20) NOT NULL
, GROSS_SALE_PRICE DECIMAL DEFAULT 0 NOT NULL
, VIN VARCHAR2(20) NOT NULL
, SALESPERSON_ID VARCHAR2(20) NOT NULL
, CUST_ID VARCHAR2(20) NOT NULL
, MILEAGE NUMBER
, SALE_DATE DATE NOT NULL
, VEHICLE_STATUS VARCHAR2(20)
, CONSTRAINT SALES_PK PRIMARY KEY
(
SALE_ID
)
);

You are part of a development team with Ace Software, Inc. who has...