Share
Explore BrainMass

Computer: SQL Data Table

I am trying to get my SQL data table to pass but it will not, can you me thanks. Here is the code:
SET echo on;
DROP TABLE COURSE CASCADE CONSTRAINTS;
DROP TABLE XCLASS CASCADE CONSTRAINTS;
DROP TABLE STUDENT CASCADE CONSTRAINTS;
DROP TABLE ENROLL CASCADE CONSTRAINTS;

CREATE TABLE COURSE(
CRS_CODE VARCHAR(8) NOT NULL PRIMARY KEY,
CRS_DESCRIPTION VARCHAR(35) NOT NULL,
CRS_CREDIT INT DEFAULT '4' NOT NULL
CHECK(CRS_CREDIT IN (1,2,3,4)));

CREATE TABLE XCLASS(
CLASS_CODE NUMBER(5) PRIMARY KEY,
CRS_CODE VARCHAR(8)NOT NULL,
CLASS_SECTION INT NOT NULL
CHECK(CLASS_SECTION IN (0,1,2,3,4,5,6,7,8)),
VAR_TIME VARCHAR(25) NOT NULL,
CLASS_ROOM CHAR (6),
FOREIGN KEY(CRS_CODE) REFERENCES COURSE(CRS_CODE));

CREATE TABLE STUDENT(
STU_NUM NUMBER(6) NOT NULL PRIMARY KEY,
STU_LNAME VARCHAR(25) NOT NULL,
STU_FNAME VARCHAR(20) NOT NULL,
STU_INIT CHAR (1),
STU_DOB DATE NOT NULL,
STU_HRS INT DEFAULT '0' NOT NULL
CHECK(STU_HRS <=1000),
STU_CLASS CHAR(2) NOT NULL
CHECK(STU_CLASS IN (Fr,So,Jr,Sr,Gr)),
STU_GPA NUMBER(2,2) NOT NULL
CHECK(STU_GPA <=4.00),
STU_PHONE NUMBER(4) NOT NULL );

CREATE TABLE ENROLL(
CLASS_CODE VARCHAR(8) NOT NULL,
STU_NUM NUMBER (6) NOT NULL,
ENROLL_GRADE CHAR(1) DEFAULT 'Z' NOT NULL,
CHECK(ENROLL_GRADE IN ('A,B,C,D,F,I,Z')),
PRIMARY KEY (CLASS_CODE, STU_NUM),
FOREIGN KEY (CLASS_CODE) REFERENCES STUDENT(CLASS_CODE) ON DELETE CASCADE,
FOREIGN KEY (STU_NUM) REFERENCES XCLASS(STU_NUM) ON DELETE CASCADE);
set echo off;

Solution Preview

Dear student,

Please find attached the solution.

(--Please note that my work ...

Solution Summary

An SQL data table in computers is examined.

$2.19