I am in my first database course and we are using iSQL Plus to create a simple d

Question

I am in my first database course and we are using iSQL Plus to create a simple database. The problem is that we were not told AT ALL how to actually program in this thing. I also have no idea why I have so many errors when trying to execute. I realized that I had to remove foreign key constraints and use ALTER to add them after I build the tables, but why does my code keep telling me that I am using invalid identifiers ')'? I will gladly post each question I have as a new questions, but could someone please just tell me why this code is pulling errors that state invalid identifier ')'? I will give lifesaver just for that answer, as you will truly be one. Here's the code:
CREATE SCHEMA COMPANY(
CREATE TABLE EMPLOYEE
(
Fname VARCHAR(15) NOT NULL,
Minit CHAR,
Lname VARCHAR(15) NOT NULL,
Ssn CHAR(9) PRIMARY KEY NOT NULL,
Bdate DATE,
Address VARCHAR(30),
Sex CHAR,
Salary DECIMAL(10,2),
Super_ssn CHAR(9),
Dno INT
);
CREATE TABLE DEPARTMENT
(
Dname VARCHAR(15) UNIQUE NOT NULL,
Dnumber INT PRIMARY KEY NOT NULL,
Mgr_ssn CHAR(9) NOT NULL,
Mgr_start_date DATE,
);
CREATE TABLE DEPT_LOCATIONS
(
Dnumber INT NOT NULL,
Dlocation VARCHAR(15) PRIMARY KEY NOT NULL,
);
CREATE TABLE PROJECT
(
Pname VARCHAR(15) UNIQUE NOT NULL,
Pnumber INT PRIMARY KEY NOT NULL,
Plocation VARCHAR(15),
Dnum INT NOT NULL,
);
CREATE TABLE WORKS_ON
(
Essn CHAR(9) PRIMARY KEY NOT NULL,
Pno INT NOT NULL,
Hours DECIMAL(3,1) NOT NULL,
);
CREATE TABLE DEPENDENT
(
Essn CHAR(9) NOT NULL,
Dependent_name VARCHAR(15) PRIMARY KEY NOT NULL,
Sex CHAR,
Bdate DATE,
Relationship VARCHAR(8),
);
);

Explanation / Answer

invalid identifier ) is probably due to the engine interpreting the end-of-table ) as another entitiy name: I see some commas that probably shouldn't be there after the last entity in all tables tables except EMPLOYEE. ----------------------------------- CREATE SCHEMA COMPANY( CREATE TABLE EMPLOYEE ( Fname VARCHAR(15) NOT NULL, Minit CHAR, Lname VARCHAR(15) NOT NULL, Ssn CHAR(9) PRIMARY KEY NOT NULL, Bdate DATE, Address VARCHAR(30), Sex CHAR, Salary DECIMAL(10,2), Super_ssn CHAR(9), Dno INT ); CREATE TABLE DEPARTMENT ( Dname VARCHAR(15) UNIQUE NOT NULL, Dnumber INT PRIMARY KEY NOT NULL, Mgr_ssn CHAR(9) NOT NULL, Mgr_start_date DATE ); CREATE TABLE DEPT_LOCATIONS ( Dnumber INT NOT NULL, Dlocation VARCHAR(15) PRIMARY KEY NOT NULL ); CREATE TABLE PROJECT ( Pname VARCHAR(15) UNIQUE NOT NULL, Pnumber INT PRIMARY KEY NOT NULL, Plocation VARCHAR(15), Dnum INT NOT NULL ); CREATE TABLE WORKS_ON ( Essn CHAR(9) PRIMARY KEY NOT NULL, Pno INT NOT NULL, Hours DECIMAL(3,1) NOT NULL ); CREATE TABLE DEPENDENT ( Essn CHAR(9) NOT NULL, Dependent_name VARCHAR(15) PRIMARY KEY NOT NULL, Sex CHAR, Bdate DATE, Relationship VARCHAR(8) ); );

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.