SQL 3

Create Table

query

CREATE TABLE CUSTOMERS

(

cust_ID NUMBER(10) NOT NULL,

first_name VARCHAR2(20) NOT NULL,

MI VARCHAR2(2),

last_name VARCHAR2(20) NOT NULL,

street VARCHAR2(40) NOT NULL,

address VARCHAR2(40) NOT NULL,

city VARCHAR2(20) NOT NULL,

state VARCHAR2(20) NOT NULL,

zip_code NUMBER(6) NOT NULL,

name VARCHAR2(20) NOT NULL,

profile NUMBER(10) NOT NULL,

email VARCHAR2(20) NOT NULL,

CONSTRAINT customers_pk PRIMARY KEY(cust_ID)

)

CREATE TABLE VEHICLES (

VIN NUMBER(10) NOT NULL,

type VARCHAR2(10) NOT NULL,

model VARCHAR2(20) NOT NULL,

make VARCHAR2(20) NOT NULL,

wholesale_cost NUMBER(10) NOT NULL,

wherefrom VARCHAR2(20) NOT NULL,

trade_ID VARCHAR2(10) NOT NULL,

CONSTRAINT vehicles_pk PRIMARY KEY (VIN)

)

CREATE TABLE SALE (

sale_ID DATE,

vehicle_status VARCHAR2(10) NOT NULL,

date VARCHAR2(20) NOT NULL,

mileage VARCHAR2(20) NOT NULL,

cust_ID VARCHAR2(10) NOT NULL,

VIN NUMBER(10) NOT NULL,

salesperson_ID VARCHAR2(10) NOT NULL,

gross_sale_price NUMBER(10,2) NOT NULL,

CONSTRAINT sales_pk PRIMARY KEY (sale_ID),

CONSTRAINT fk_customers

Foreign KEY (cust_ID) REFERENCES customers(cust_ID),

CONSTRAINT fk_vehicles FOREIGN KEY (VIN) REFERENCES VEHICLES(VIN)

)

Add foreign key