Question: /*create the ENROLL table */ CREATE TABLE ENROLL( CLASS_CODE NUMBER(5,0) NOT NULL, STU_NUM INTEGER NOT NULL, ENROLL_GRADE CHAR(1) DEFAULT 'Z' NOT NULL CHECK(ENROLL_GRADE IN('A','B','C','D','F','I','W','Z'), PRIMARY

/*create the ENROLL table */ CREATE TABLE ENROLL( CLASS_CODE NUMBER(5,0) NOT NULL, STU_NUM INTEGER NOT NULL, ENROLL_GRADE CHAR(1) DEFAULT 'Z' NOT NULL CHECK(ENROLL_GRADE IN('A','B','C','D','F','I','W','Z'), PRIMARY KEY(CLASS_CODE,STU_NUM), CONSTRAINT FK_CLASS_CODE FOREIGN KEY (CLASS_CODE) REFERENCES CLASS(CLASS_CODE), CONSTRAINT FK_STU_NUM FOREIGN KEY (STU_NUM) REFERENCES STUDENT(STU_NUM) );

In oracle I get error: ORA-00907: missing right parenthesis. How do I fix?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

CHAPTER 3 1. Which of the following is a correct statement? a. You can restore the data deleted with the DROP COLUMN clause, but not the data deleted with the SET UNUSED clause. b. You cant create...

Q:

/* SQL file creates Tables and Inserts DAta into Tables */ select systimestamp from dual; /*create the COURSE table*/ CREATE TABLE COURSE( CRS_CODE VARCHAR(8) NOT NULL, CRS_DESCRIPTION VARCHAR(35)...

Q:

Need help with these portions of code: REM insert data into the CLASS table (first record given) INSERT INTO CLASS VALUES(10012,'ACCT-211',1,'MWF 8:00-8:50 a.m.','BUS311'); REM insert data into the...

Q:

Need help with these SQL, did some of it. CREATE TABLE COURSE ( CRS_CODE VARCHAR(8) NOT NULL, CRS_DESCRIPTION VARCHAR(35) NOT NULL, CRS_CREDIT INTEGER DEFAULT 4 NOT NULL CHECK(CRS_CREDIT IN...

Q:

Need help with section #2 towards the bottom. (REM INSERT DATA INTO TABLES (#2)) CREATE TABLE COURSE ( CRS_CODE VARCHAR(8) NOT NULL, CRS_DESCRIPTION VARCHAR(35) NOT NULL, CRS_CREDIT INTEGER DEFAULT 4...

Q:

BEFORE YOU START 1. Connect to SQL server management studio. 2. Click the arrow next to your server. 3. Right-click the Databases folder. 4. In the context menu, select New Database. 5. Enter the...

Q:

INTRODUCTION The purpose of this assignment is to gain more SQL experience using Oracle. In particular, you will get practice creating tables, inserting data into tables, and performing updates and...

Q:

Tables_bookstore_database: USE bookstore; /* drop the tables */ DROP TABLE IF EXISTS orderitems; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS customer; DROP TABLE...

Q:

Assignment 5: Hash Table implementation andconcordance There are three parts to this assignment. In the first two parts,you will complete the implementation of a hash map and aconcordance program. In...

Q:

CSIS 325 Lab 4 (SQL CREATE TABLE) Before beginning this lab, be sure you have successfully downloaded and installed SQL Server Express 2014: (You should have already done this in your first lab, but...

Q:

(a) If the observation marked with an à in the following plot is removed, how will the slope of the least squares line change? (b) What will happen to r2 and se? (c) Is this observation...

Q:

What is the difference between postponement and channel assembly?

Q:

E2.8 (LO 3) (Adjusting Entries) William Bryant is the new owner of Ace Computer Services. At the end of August 2025, his first month of ownership, Bryant is trying to prepare monthly financial...

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

Explain the purpose of the Project Charter and its relationship to Management Approval for a Project.

Q:

What is Change Control and how does it operate?

Q:

How do Data Requirements relate to Functional Requirements?