UC知道SQL SEVER 建表的问题
来源：百度知道 编辑：UC知道 时间：2024/06/22 08:21:06
CREATE TABLE Student
(SNO CHAR(4) NOT NULL PRIMARY KEY(SNO),
SNAME VARCHAR(20),
SEX CHAR(2) DEFAULT '男'CHECK(SEX='男' OR SEX='女'),
AGE SMALLINT CHECK(AGE>=15 AND AGE<=45),
CLASS CHAR(5));
CREATE TABLE Course
(CNO CHAR(4) NOT NULL PRIMARY KEY(CNO),
CNAME VARCHAR(40),
TNO CHAR(3));
CREATE TABLE SC
(SNO CHAR(4) NOT NULL CONSTRAINT C_F FOREIGN KEY REFERENCES Student(SNO),
CNO CHAR(4) NOT NULL,
GRADE SMALLINT CHECK ((GRADE IS NULL) OR (GRADE BETWEEN 0 AND 100)),
PRIMARY KEY(SNO,CNO),
FOREIGN KEY(CNO) REFERENCES Course(CNO));
CREATE TABLE Teacher
(TNO CHAR(3) NOT NULL PRIMARY KEY(TNO),
TANME VARCHAR(20),
SEX CHAR(2) DEFAULT '男'CHECK(SEX='男' OR SEX='女'),
AGE SMALLINT CHECK(AGE>=18 AND AGE<=70),
PROF VARCHAR(40),
DEPT VARCHAR(40));
INSERT INTO Student VALUES('9803','李华','男',
(SNO CHAR(4) NOT NULL PRIMARY KEY(SNO),
SNAME VARCHAR(20),
SEX CHAR(2) DEFAULT '男'CHECK(SEX='男' OR SEX='女'),
AGE SMALLINT CHECK(AGE>=15 AND AGE<=45),
CLASS CHAR(5));
CREATE TABLE Course
(CNO CHAR(4) NOT NULL PRIMARY KEY(CNO),
CNAME VARCHAR(40),
TNO CHAR(3));
CREATE TABLE SC
(SNO CHAR(4) NOT NULL CONSTRAINT C_F FOREIGN KEY REFERENCES Student(SNO),
CNO CHAR(4) NOT NULL,
GRADE SMALLINT CHECK ((GRADE IS NULL) OR (GRADE BETWEEN 0 AND 100)),
PRIMARY KEY(SNO,CNO),
FOREIGN KEY(CNO) REFERENCES Course(CNO));
CREATE TABLE Teacher
(TNO CHAR(3) NOT NULL PRIMARY KEY(TNO),
TANME VARCHAR(20),
SEX CHAR(2) DEFAULT '男'CHECK(SEX='男' OR SEX='女'),
AGE SMALLINT CHECK(AGE>=18 AND AGE<=70),
PROF VARCHAR(40),
DEPT VARCHAR(40));
INSERT INTO Student VALUES('9803','李华','男',
INSERT INTO SC VALUES('9803','8104',67);
INSERT INTO SC VALUES('9804','8244',96);
INSERT INTO SC VALUES('9805','8104',86);
INSERT INTO SC VALUES('9806','8244',76);
INSERT INTO SC VALUES('9807','8104',45);
INSERT INTO SC VALUES('9808','8244',76);
INSERT INTO SC VALUES('9809','8104',87);
INSERT INTO SC VALUES('9803','8105',86);
INSERT INTO SC VALUES('9804','8245',76);
INSERT INTO SC VALUES('9805','8105',56);
INSERT INTO SC VALUES('9806','8245',96);
INSERT INTO SC VALUES('9807','8105',85);
INSERT INTO SC VALUES('9808','8245',79);
INSERT INTO SC VALUES('9809','8105',95);
在插入这组数据时发生了错误!!!!!!!!
FOREIGN KEY(CNO) REFERENCES Course(CNO)
你用上面这条语句在 course(cno)和sc(