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

老爷子88

　　为实现试验数据库系统概论 （萨师璇 王珊）课本的全部实例，下面把用到的三个基表的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