Need some help with SQL Code?

[menw]

I'm having some issues with some SQL code I'm trying to write here's my code so far:


CREATE TABLE SD_LOCATION
(LOC_ID NUMBER (2),
BLDG_CODE CHAR (3) NOT NULL,
ROOM NUMBER (3),
CAPACITY NUMBER (3),
CONSTRAINT LOC_ID_PK PRIMARY KEY (LOC_ID));

CREATE TABLE SD_FACULTY
(F_ID NUMBER(4) NOT NULL,
F_LAST CHAR (12),
F_FIRST CHAR (12),
F_MI CHAR (1),
LOC_ID NUMBER (2),
F_PHONE NUMBER (12),
F_RANK CHAR (4),
F_PIN NUMBER (4),
CONSTRAINT F_ID_PK PRIMARY KEY (F_ID),
CONSTRAINT F_RANK_CK CHECK (F_RANK IN('ASSO', 'INST', 'ASST', 'FULL')));

CREATE TABLE SD_STUDENT
(S_ID NUMBER(12) NOT NULL,
S_LAST CHAR (12) NOT NULL,
S_FIRST CHAR (12) NOT NULL,
S_MI CHAR (1),
S_ADDRESS VARCHAR (20) NOT NULL,
S_CITY CHAR (12) NOT NULL,
S_STATE CHAR (2) NOT NULL,
S_ZIP NUMBER (8) NOT NULL,
S_PHONE NUMBER (12) NOT NULL,
S_CLASS CHAR (2) DEFAULT 'FR',
S_DOB DATE,
S_PIN NUMBER (4) NOT NULL,
F_ID NUMBER (2),
TIME_ENROLLED VARCHAR (20),
CONSTRAINT S_ID_PK PRIMARY KEY (S_ID),
CONSTRAINT S_CLASS_CK CHECK (S_CLASS IN('FR', 'SO', 'JR', 'SR')));

CREATE TABLE SD_TERM
(TERM_ID NUMBER (2) NOT NULL,
TERM_DESC VARCHAR (10),
STATUS CHAR (8) DEFAULT 'CLOSED',
CONSTRAINT TERM_ID_PK PRIMARY KEY (TERM_ID),
CONSTRAINT STATUS_CK CHECK (STATUS IN('CLOSED','OPEN')));


CREATE TABLE SD_COURSE
(COURSE_ID NUMBER (2) NOT NULL,
CALL_ID VARCHAR (10) NOT NULL,
COURSE_NAME VARCHAR(20) NOT NULL,
CREDITS NUMBER (1) DEFAULT 0,
CONSTRAINT COURSE_ID_PK PRIMARY KEY (COURSE_ID),
CONSTRAINT CREDITS_CK CHECK (CREDITS IN('1','2','3','4')));

CREATE TABLE SD_COURSE_SECTION
(C_SEC_ID NUMBER (2) NOT NULL,
COURSE_ID NUMBER (2) NOT NULL,
TERM_ID NUMBER (2) NOT NULL,
SEC_NUM NUMBER (1) NOT NULL,
F_ID NUMBER (2),
C_SEC_DAY CHAR (6),
C_SEC_TIME VARCHAR (10) NOT NULL,
C_SEC_DURATION VARCHAR (20) NOT NULL,
LOC_ID NUMBER (2),
MAX_ENRL NUMBER (3) NOT NULL,
CONSTRAINT C_SEC_ID_PK PRIMARY KEY (C_SEC_ID),
CONSTRAINT C_SEC_DAY_CK CHECK (C_SEC_DAY IN('MTWRF','MWF','TR')));

CREATE TABLE SD_ENROLLMENT
(S_ID NUMBER (2),
C_SEC_ID NUMBER (2),
GRADE CHAR (1),
CONSTRAINT SD_ENROLLMENT_CPK PRIMARY KEY (S_ID, C_SEC_ID));

ALTER TABLE SD_STUDENT
ADD CONSTRAINT F_ID_FK FOREIGN KEY (F_ID)
REFERENCES SD_FACULTY(F_ID);

ALTER TABLE SD_FACULTY
ADD CONSTRAINT LOC_ID_FK FOREIGN KEY (LOC_ID)
REFERENCES SD_LOCATION(LOC_ID);

ALTER TABLE SD_ENROLLMENT
ADD CONSTRAINT S_ID_KF FOREIGN KEY (S_ID)
REFERENCES SD_STUDENT(S_ID);

ALTER TABLE SD_COURSE_SELECTION
ADD CONSTRAINT TERM_ID_FK FOREIGN KEY (TERM_ID)
REFERENCES SD_TERM(TERM_ID);




ALTER TABLE SD_COURSE_SELECTION
ADD CONSTRAINT FK_FID FOREIGN KEY (F_ID)
REFERENCES SD_FACULTY(F_ID);

ALTER TABLE SD_COURSE_SELECTION
ADD CONSTRAINT FK_LOC FOREIGN KEY (LOC_ID)
REFERENCES SD_LOCATION(LOC_ID);


What I am running into begins at line 87, and I get the following error messages from SQL Developer:
Error starting at line 87 in command:
ALTER TABLE SD_COURSE_SELECTION
ADD CONSTRAINT TERM_ID_FK FOREIGN KEY (TERM_ID)
REFERENCES SD_TERM(TERM_ID)
Error report:
SQL Error: ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
*Cause:
*Action:

Error starting at line 94 in command:
ALTER TABLE SD_COURSE_SELECTION
ADD CONSTRAINT FK_FID FOREIGN KEY (F_ID)
REFERENCES SD_FACULTY(F_ID)
Error report:
SQL Error: ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
*Cause:
*Action:

Error starting at line 98 in command:
ALTER TABLE SD_COURSE_SELECTION
ADD CONSTRAINT FK_LOC FOREIGN KEY (LOC_ID)
REFERENCES SD_LOCATION(LOC_ID)
Error report:
SQL Error: ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
*Cause:
*Action:

[mohammed47]

SQL Return Codes are used on a day to day basis for the diagnosis of programming failures as a result of SQL calls by DB2 computer programs. An important feature of DB2 programs is the error processing. The error diagnostic containing the SQL Return Code is held in the field SQLCODE within the DB2 SQLCA block.

[werner72]

It's just a typo:

SD_COURSE_SECTION -- What you called the table
SD_COURSE_SELECTION -- Table you tried to create constraint on.