SQL PLUS(ORACLE)

profilejontha11

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
    Answer(1)

    Purchase the answer to view it

    blurred-text