实验3代码.docVIP

create database EDUC on (name=student_data, filename=D:\ student_data.mdf, size=10MB, maxsize=50MB, filegrowth=5% ) log on (name=student_log, filename=D:\ student_log.ldf, size=2MB, maxsize=5MB, filegrowth=1MB ) create table student ( sno char(5) primary key, sname char(8) not null, ssex char(2), dno char(20), birthday smalldatetime, entime smalldatetime, native char(20), policy char(10) ) create table teacher ( tno char(5) primary key, tname char(8) not null, sex char(2), birthday smalldatetime, dno char(20), education char(10), pname char(10) ) create table course ( cno char(5) primary key, cname char(20) not null, credit tinyint, semester tinyint, tno char(5), foreign key(tno) references teacher(tno) ) create table sc ( sno char(5) not null, cno char(5) not null, score decimal(5,1), primary key(sno,cno), foreign key(sno) references student(sno), foreign key(cno) references course(cno), ) alter table sc add id int identity(1,1),qdtime datetime alter table sc alter column qdtime smalldatetime alter table sc drop column id,qdtime insert student values (10000,高黎明,男,计算机学院,1986-11-05,2004-9-12,北京,团员) insert student values (10001,张强,男,计算机学院,1985-01-14,2004-9-12,洛阳,党员) insert student values (10002,王亚伟,男,计算机学院,1988-03-04,2005-9-15,重庆,党员) insert student values (10003,牛晶晶,女,计算机学院,1988-03-25,2005-9-15,北京,团员) insert student values (10004,张伟,男,计算机学院,1989-10-15,2006-9-10,上海,党员) insert student values (10005,马永慧,女,计算机学院,1987-06-14,2006-9-10,广州,团员) insert student values (10006,孟战,男,计算机学院,1986-08-01,2006-9-10,郑州,党员) insert student values (10007,黄永超,男,计算机学院,1986-07-05,2006-9-10,重庆,党员) insert student values (10008,王建国,男,体育学院,1986-02-27,2005-9-15,北京,团员) insert student values (10009,刘防超,男,体育学院,1986-01-03,2004-9-12,上海,党员) insert student values (10010,王莹莹,女,体育学院,1986-05-10,2004-9-12,洛阳,团员) insert student values (10011,张亚菲,女,体育学院,1986-05-09,2005-9-15,郑州,党员) insert student values (10012,王刚,男,体育学院,1986-12-02,2005-9-15,天津,团员) insert student values (10013,李刚,男,历史文化学院,1986-12-19,2006-9-10,北京,团