【正文】 AT(8) NULL, PRIMARY KEY (CID) ) GO 9 /*創(chuàng)建特長(zhǎng)表 */ CREATE TABLE SPEC( SPID CHAR(5) NOT NULL, SPNAME VARCHAR(10) NOT NULL, SPECT VARCHAR(20) NULL, PRIMARY KEY(SPID) ) GO /*創(chuàng)建系部表 */ CREATE TABLE DEPT( DEPID CHAR(4) NOT NULL, DEPNAME VARCHAR(10) NOT NULL, DLEAD VARCHAR(20) NULL, PRIMARY KEY(DEPID) ) GO /*創(chuàng)建選課表 */ CREATE TABLE SELECTS( SID CHAR(11) NOT NULL, CID CHAR(5) NOT NULL, GRADE SMALLINT NOT NULL, PRIMARY KEY(SID, CID) ) GO 10 /*創(chuàng)建講授表 */ CREATE TABLE TEACHING( CID CHAR(5) NOT NULL, TID CHAR(11) NOT NULL, TDATE DATETIME NULL, PRIMARY KEY(CID,TID) ) GO /*創(chuàng)建愛好表 */ CREATE TABLE BEFOND( SID CHAR(11) NOT NULL, SPID CHAR(5) NOT NULL, RANK CHAR(4) NULL, PRIMARY KEY(SID,SPID) ) GO /*創(chuàng)建管理表 */ CREATE TABLE MANAG( DEPID CHAR(10) NOT NULL, SID CHAR(11) NOT NULL, ENDATE DATETIME NULL, PRIMARY KEY(DEPID,SID) ) GO 11 /*????? 插入表的信息 ????? */ /*............插入 STUDENTS學(xué)生信息表 ...........*/ USE STUDENTINFO GO INSERT INTO STUDENT VALUES(39。,39。,39。,39。,39。) INSERT INTO STUDENT VALUES(39。,39。,39。,39。,39。) INSERT INTO STUDENT VALUES(39。,39。,39。,39。,39。) INSERT INTO STUDENT VALUES(39。,39。,39。,39。,39。) INSERT INTO STUDENT VALUES(39。,39。,39。,39。,39。) INSERT INTO STUDENT VALUES(39。,39。,39。,39。,39。) INSERT INTO STUDENT VALUES(39。,39。,39。,39。,39。) INSERT INTO STUDENT VALUES(39。,39。,39。,39。,39。) INSERT INTO STUDENT VALUES(39。,39。,39。,39。,39。) INSERT INTO STUDENT VALUES(39。,39。,39。,39。,39。) INSERT INTO STUDENT VALUES(39。,39。,39。,39。,39。) INSERT INTO STUDENT VALUES(39。,39。,39。,39。,39。) INSERT INTO STUDENT VALUES(39。,39。,39。,39。,39。) INSERT INTO STUDENT VALUES(39。,39。,39。,39。,39。) INSERT INTO STUDENT VALUES(39。,39。,39。,39。,39。) 12 /*............插入 TEACHER教師表 ...........*/ USE STUDENTINFO GO INSERT INTO TEACHER VALUES(39。,39。,39。,39。,39。) INSERT INTO TEACHER VALUES(39。,39。,39。,39。,39。) INSERT INTO TEACHER VALUES(39。,39。,39。,39。,39。) INSERT INTO TEACHER VALUES(39。,39。,39。,39。,39。) INSERT INTO TEACHER VALUES(39。,39。,39。,39。,39。) INSERT INTO TEACHER VALUES(39。,39。,39。,39。,39。) INSERT INTO TEACHER VALUES(39。,39。,39。,39。,39。) INSERT INTO TEACHER VALUES(39。,39。,39。,39。,39。) /*............插入 COURSE課程表 ...........*/ USE STUDENTINFO GO INSERT INTO COURSE VALUES(39。,39。,39。) INSERT INTO COURSE VALUES(39。,39。,39。) INSERT INTO COURSE VALUES(39。,39。,39。) INSERT INTO COURSE VALUES(39。,39。,39。) INSERT INTO COURSE VALUES(39。,39。,39。) INSERT INTO COURSE VALUES(39。,39。,39。) INSERT INTO COURSE VALUES(39。,39。,39。) INSERT INTO COURSE VALUES(39。,39。,39。) 13 /*............插入 SPEC特長(zhǎng)表 ...........*/ USE STUDENTINFO GO INSERT INTO SPEC VALUES(39。,39。,39。) INSERT INTO SPEC VALUES(39。,39。,39。) INSERT INTO SPEC VALUES(39。,39。,39。) INSERT INTO SPEC VALUES(39。,39。,39。) INSERT INTO SPEC VALUES(39。,39。,39。) INSERT INTO SPEC VALUES(39。,39。,39。) INSERT INTO SPEC VALUES(39。,39。,39。) /*............插入 DEPT系部表 ...........*/ USE STUDENTINFO GO INSERT INTO DEPT VALUES(39。,39。,39。) INSERT INTO DEPT VALUES(39。,39。,39。) INSERT INTO DEPT VALUES(39。,39。,39。) INSERT INTO DEPT VALUES(39。,39。,39。) 14 /*............插入 SELECTS選課表 ...........*/ USE STUDENTINFO GO INSERT INTO SELECTS VALUES(39。,39。,39。) INSERT INTO SELECTS VALUES(39。,39。,39。) INSERT INTO SELECTS VALUES(39。,39。,39。) INSERT INTO SELECTS VALUES(39。,39。,39。) INSERT INTO SELECTS VALUES(39。,39。,39。) INSERT INTO SELECTS VALUES(39。,39。,39。) INSERT INTO SELECTS VALUES(39。,39。,39。) INSERT INTO SELECTS VALUES(39。,39。,39。) INSERT INTO SELECTS VALUES(39。,39。,39。) INSERT INTO SELECTS VALUES(39。,39。,39。) INSERT INTO SELECTS VALUES(39。,39。,39。) INSERT INTO SELECTS VALUES(39。,39。,39。) INSERT INTO SELECTS VALUES(39。,39。,39。) INSERT INTO SELECTS VALUES(39。,39。,39。) INSERT INTO SELECTS VALUES(39。,39。,39。) 15 /*............插入 TEACHING講授表 ...........*/ USE STUDENTINFO GO INSERT INTO TEACHING VALUES(39。,39。,39。) INSERT INTO TEACHING VALUES(39。,39。,39。) INSERT INTO TEACHING VALUES(39。,39。,39。) INSERT INTO TEACHING VALUES(39。,39。,39。) INSERT INTO TEACHING VALUES(39。,39。,39。) INSERT INTO TEACHING VALUES(39。,39。,39。) INSERT INTO TEACHING VALUES(39。,39。,39。) INSERT INTO TEACHING VALUES(39。,39。,39。) 16 /*............插入 BEFOND愛好表 ...........*/ USE STUDENTINFO GO INSERT INTO BEFOND VALUES(39。,39。,39。) INSERT INTO BEFOND VALUES(39。,39。,39。) INSERT INTO BEFOND VALUES(39。,39。,39。) INSERT INTO BEFOND VALUES(39。,39。,39。) INSERT INTO BEFOND VALUES(39。,39。,39。) INSERT INTO BEFOND VALUES(39。,39。,39。) INSERT INTO BEFOND VALUES(39。,39。,39。) INSERT INTO BEFOND VALUES(39。,39。,39。) INSERT INTO BEFOND VALUES(39。,39。,39。) INSERT INTO BEFOND VALUES(39。,39。,39。) INSERT INTO BEFOND VALUES(39。,39。,39。) INSERT INTO BEFOND V