Purchase Solution

Computer: SQL Data Table

Not what you're looking for?

Ask Custom Question

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;

Purchase this Solution

Solution Summary

An SQL data table in computers is examined.

Solution Preview

Dear student,

Please find attached the solution.

(--Please note that my work ...

Purchase this Solution


Free BrainMass Quizzes
Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.