I was able to create all the tables below except
ENROLLS. Can anyone please help me what is wrong in my
syntax in the section that faild to create the ENROLLS
table.
CREATE TABLE STUDENTS
(studentID SMALLINT NOT NULL,
student_name char(18),
address char(20),
city char(10),
state char(2),
zip char(5),
gender char(1),
PRIMARY KEY (studentID))TYPE=INNODB;
CREATE TABLE TEACHERS
(teacherID SMALLINT NOT NULL,
teacher_name char(18),
phone char(10),
salary FLOAT, PRIMARY KEY(teacherID))TYPE=INNODB;
CREATE TABLE COURSES
(courseID SMALLINT NOT NULL,
course_name char(20),
department char(16),
num_credits SMALLINT,
PRIMARY KEY(courseID))TYPE=INNODB;
CREATE TABLE SECTIONS
(courseID SMALLINT NOT NULL,
sectionID SMALLINT NOT NULL,
teacherID SMALLINT,
num_students SMALLINT,
PRIMARY KEY(courseID,sectionID),
INDEX(courseID),
FOREIGN KEY(courseID)
REFERENCES COURSES(courseID)
ON UPDATE CASCADE ON DELETE CASCADE)TYPE=INNODB;
CREATE TABLE ENROLLS
(enrollmentID INT NOT NULL AUTO_INCREMENT,
courseID SMALLINT NOT NULL,
sectionID SMALLINT NOT NULL,
studentID SMALLINT NOT NULL,
grade SMALLINT,
PRIMARY KEY(enrollmentID),
INDEX(courseID),
REFERENCES COURSES(courseID)ON UPDATE CASCADE ON
DELETE CASCADE,
INDEX(sectionID),
REFERENCES SECTIONS(sectionID)ON UPDATE CASCADE ON
DELETE CASCADE,
INDEX(studentID),
REFERENCES STUDENTS(studentID)ON UPDATE CASCADE ON
DELETE CASCADE)TYPE=INNODB;
Maru
_______________________________
Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter now.
http://promotions.yahoo.com/goldrush
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
