数据库系统概论（萨师煊 王珊）课本例子 基表的MYSQL 语言实现

为实现试验数据库系统概论 （萨师璇 王珊）课本的全部实例，下面把用到的三个基表的MYSQL 语言实现列在下面。

Create table STUDENT ( Sno char (10) not null, Sname char(10) not null, Ssex Char (2), Sage int,Sdept char (10), Primary key(Sno)) ENGINE =INNODB; insert into STUDENT(SNO,SNAME,Ssex,Sage,Sdept) values (95001,'李勇','男',20,'CS'); insert into STUDENT(SNO,SNAME,Ssex,Sage,Sdept) values (95002,'刘晨','男',19,'IS'); insert into STUDENT(SNO,SNAME,Ssex,Sage,Sdept) values (95003,'王敏','女',18,'MA'); insert into STUDENT(SNO,SNAME,Ssex,Sage,Sdept) values (95004,'张莉','女',20,'IS'); Create table Course ( Cno int not null, Cname char(20) not null, Cpno int, Ccredit int,Primary key(CNO)) ENGINE =INNODB; insert into COURSE(CNO,CNAME,Cpno , Ccredit ) values (1,'数据库',5,4); insert into COURSE(CNO,CNAME,Cpno , Ccredit) values (2,'数学',NULL,2); insert into COURSE(CNO,CNAME,Cpno , Ccredit) values (3,'信息系统',1,4); insert into COURSE(CNO,CNAME,Cpno , Ccredit) values (4,'操作系统',6,3); insert into COURSE(CNO,CNAME,Cpno , Ccredit) values (5,'数据结构',7,4); insert into COURSE(CNO,CNAME,Cpno , Ccredit) values (6,'数据处理',null,2); insert into COURSE(CNO,CNAME,Cpno , Ccredit) values (7,'pascal语言',6,4); Create table SC( Sno char (10) NOT NULL, CNO int NOT NULL, grade int,Primary key(SNO,CNO), FOREIGN key (SNO) references STUDENT(SNO) on delete cascade, FOREIGN key (CNO) references COURSE(CNO) on delete restrict) ENGINE =INNODB; insert into SC(SNO,CNO,grade ) values (95001,1,92); insert into SC(SNO,CNO,grade ) values (95001,2,85); insert into SC(SNO,CNO,grade ) values (95001,3,88); insert into SC(SNO,CNO,grade ) values (95002,2,90); insert into SC(SNO,CNO,grade ) values (95002,3,80);

下面是提示信息：

[SQL] insert into COURSE(CNO,CNAME,Cpno , Ccredit) values (5,'数据结构',7,4); 影响的数据栏: 1 时间: 0.030ms [SQL] insert into COURSE(CNO,CNAME,Cpno , Ccredit) values (6,'数据处理',null,2); 影响的数据栏: 1 时间: 0.030ms [SQL] insert into COURSE(CNO,CNAME,Cpno , Ccredit) values (7,'pascal语言',6,4); 影响的数据栏: 1 时间: 0.040ms [SQL] Create table SC( Sno char (10) NOT NULL, CNO int NOT NULL, grade int,Primary key(SNO,CNO), FOREIGN key (SNO) references STUDENT(SNO) on delete cascade, FOREIGN key (CNO) references COURSE(CNO) on delete restrict) ENGINE =INNODB; 影响的数据栏: 0 时间: 0.140ms [SQL] insert into SC(SNO,CNO,grade ) values (95001,1,92); 影响的数据栏: 1 时间: 0.030ms [SQL] insert into SC(SNO,CNO,grade ) values (95001,2,85); 影响的数据栏: 1 时间: 0.030ms [SQL] insert into SC(SNO,CNO,grade ) values (95001,3,88); 影响的数据栏: 1 时间: 0.040ms [SQL] insert into SC(SNO,CNO,grade ) values (95002,2,90); 影响的数据栏: 1 时间: 0.040ms [SQL] insert into SC(SNO,CNO,grade ) values (95002,3,80); 影响的数据栏: 1 时间: 0.070ms