学生成绩管理系统DB2.docVIP

学生成绩管理系统数据库 Create database StuData connect to StuData 新建表1 create Table tbl_StudentInfo(stuno char(5)not null, stuname varchar(20) not null,stubirth date,stusex num(1),stuaddr varchar(200),stutel varchar(11)) 插入语句 insert into tbl_StudentInfo values(05001,张三, 1988-12-12,0, 江苏南京, 12345) insert into tbl_StudentInfo values(05002,李四, 1987-06-05,1, 上海, 12346) insert into tbl_StudentInfo values(05003,王五, 1987-12-01,0, 北京, 12347) insert into tbl_StudentInfo values(05004,赵六, 1986-02-23,1, 广东深圳, 12348) insert into tbl_StudentInfo values(05005,张三, 1988-04-01,0, 重庆, 12349) insert into tbl_StudentInfo values(05006,孙七, 1988-07-03,0, 湖北武汉, ) 新建表2 create Table tbl_ClassInfo(classno char(3)not null,classname varchar(10)not null) 插入语句 insert into tbl_ClassInfo values(001, 计算机) insert into tbl_ClassInfo values(002, 日语) insert into tbl_ClassInfo values(003, 英语) 新建表3 create Table tbl_ScoreInfo(stuno char(5)not null, classno varchar(3)not null, score int) 插入语句 insert into tbl_ScoreInfo values(05001,001,95) insert into tbl_ScoreInfo values(05001,002,90) insert into tbl_ScoreInfo values(05001,003,88) insert into tbl_ScoreInfo values(05002,001,91) insert into tbl_ScoreInfo values(05002,002,93) insert into tbl_ScoreInfo values(05002,003,88) insert into tbl_ScoreInfo values(05003,001,95) insert into tbl_ScoreInfo values(05003,002,73) insert into tbl_ScoreInfo values(05003,003,58) insert into tbl_ScoreInfo values(05004,001,47) insert into tbl_ScoreInfo values(05004,003,61) insert into tbl_ScoreInfo values(05005,002,59) insert into tbl_ScoreInfo values(05005,003,47) 查询表 select * from tbl_StudentInfo select * from tbl_ClassInfo select * from tbl_ScoreInfo 、