school数据库创建过程.doc

create database school on( name=school_data, filename=E:\school_data.mdf, size=10mb, maxsize=500mb, filegrowth=10% ), ( name=school_data2, filename=E:\school_data2.ldf, size=2mb, maxsize=30mb, filegrowth=5mb ) use school create table t ( tno varchar(8) not null, tname varchar(10) not null, tsex varchar(4), tage smallint , tprof varchar(10), tsal smallint, tcomm smallint, tdept varchar(20) ) create table s ( sno varchar(8) not null, sname varchar(10) not null, ssex varchar(4), sage smallint, sdept varchar(20) ) create table c ( cno varchar(8) not null, cname varchar(20) not null, ct smallint ) create table sc ( sno varchar(8) not null, cno varchar(8) not null, score smallint ) 朱伟(308351909) 13:39:17 ) create table tc ( tno varchar(8) not null, cno varchar(8) not null, ) insert into t(tno,tname,tsex,tage,tprof,tsal,tcomm,tdept) values (t1,李力,男,47,教授,1800,3000,计算机) insert into t(tno,tname,tsex,tage,tprof,tsal,tcomm,tdept) values (t2,王平,女,28,讲师,850,1200,信息) insert into t(tno,tname,tsex,tage,tprof,tsal,tcomm,tdept) values (t3,刘伟,男,30,讲师,1000,1200,计算机) insert into t(tno,tname,tsex,tage,tprof,tsal,tcomm,tdept) values (t4,张雪,女,51,教授,1900,3000,自动化) insert into t(tno,tname,tsex,tage,tprof,tsal,tcomm,tdept) values (t5,张兰,女,39,副教授,1500,3000,信息) select * from t insert into s(sno,sname,ssex,sage,sdept) values (s1,赵义,女,17,计算机) insert into s(sno,sname,ssex,sage,sdept) values (s2,钱尔,男,18,信息) insert into s(sno,sname,ssex,sage,sdept) values (s3,孙珊,女,20,信息) insert into s(sno,sname,ssex,sage,sdept) values (s4,李思,男,21,自动化) insert into s(sno,sname,ssex,sage,sdept) values (s5,周武,男,19,计算机) insert into s(sno,sname,ssex,sage,sdept) values (s6,吴丽,女,20,自动化) 朱伟(308351909) 13:39:28 select * from s insert into sc(sno,cno,score) values (s1,c2,85) insert into sc(sno,cno,score) values (s1,c5,100) insert into sc(sno,cno,score) values (s2,c5,60) insert into sc(sno,cno,score) values (s2,c6,80) insert into sc(sno,cno) values (s2,c7) insert into sc(sno,cno,score) values (s3,c2,70) insert int