Explore BrainMass
Share

Explore BrainMass

    Computer: SQL Data Table

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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;

    © BrainMass Inc. brainmass.com October 10, 2019, 6:02 am ad1c9bdddf
    https://brainmass.com/computer-science/sql/computer-sql-data-table-526537

    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