SQL PLUS(ORACLE)
I NEED help trying to get my foreign key to compile.
Check my code on the tables, please let me know what is wrong here:
CREATE TABLE REP( REP_ID char(3), REP_LNAME varchar(20) NOT NULL,
REP_FNAME varchar(20) NOT NULL, REP_STREET char(15), REP_CITY varchar(20) NOT NULL,
REP_STATE char(2), REP_ZIP char(5), REP_COMM decimal(7,2),
REP_RATE decimal(2,2),PRIMARY KEY(REP_ID));
CREATE TABLE CUSTOMER( CUST_ID char(4), CUST_NAME varchar(50) NOT NULL,
CUST_STREET char(20), CUST_CITY varchar(20) NOT NULL, CUST_STATE char(2),
CUST_ZIP char(5), CUST_BALANCE decimal(7,2), CUST_LIMIT decimal(7,2),
PRIMARY KEY(CUST_ID),
FOREIGN KEY(REP_ID) REFERENCES REP);
CREATE TABLE PRODUCT( PROD_ID char(5), PROD_DESC varchar(30) NOT NULL,
PROD_QUANTITY char(3), PROD_TYPE char(2), PROD_WAREHOUSE char(1),
PROD_PRICE decimal(5,2),
PRIMARY KEY(PROD_ID);
CREATE TABLE INVOICE( INVOICE_NUM char(5), INVOICE_DATE DATE,
FOREIGN KEY(CUST_ID) references CUSTOMER(CUST_ID));
CREATE TABLE LINE (LINE_NUM_ORDERED char(2), LINE_PRICE decimal(5,2),
FOREIGN KEY(INVOICE_NUM) references INVOICE(INVOICE_NUM));
FOREIGN KEY(PROD_ID) references PRODUCT(PROD_ID));
12 years ago
20
Purchase the answer to view it

- ECO - Gaby's rate of return to years of education
- Describe market equilibrium under monopolistic competition.
- 111111
- Why is Athens better than Sparta?
- Chapter 7 Assignment
- EED 415 Week 5 Final Individual Teaching Experience Reflection
- EE 372 Lab Assignment Optical Sensors
- DBM 502 Week 4 Individual Assignmnet Benefits of Fleet Management Data Integration
- COM 215 Week 1 Ryon Kosino Grammar Guide Results
- WEB 240 Week 1-5 Entire course