《《网络数据库》期中作业-学生成绩管理系统设计》由会员分享，可在线阅读，更多相关《《网络数据库》期中作业-学生成绩管理系统设计（18页珍藏版）》请在金锄头文库上搜索。
1、网络数据库期中作业课题：学生成绩管理系统 2011年05月17日学生成绩管理系统、学生成绩管理系统设计背景本项目的设计者是08电信（2）第十四小组，服务对象是西北民族大学在校学生，用户是学生、办公室。由于考试后成绩整理及成绩查询所耗费的时间较大，所以开发此软件对学生成绩进行管理。具体包括以下的内容:（1）某大学有若干名学生，每个学生每学期必须学习若干门课程。（2）每个学生有学号、姓名、班级等基本信息。（3）没门课程有课程号课程名称、任课教师、学分等信息。（4）学校需要对学生的基本信息、所学课程、成绩进行统一管理，以便于对信息进行查询、浏览和修改。根据其建立的表有stuxx、teaxx、stuz
2、y、choose、course表。choose（学号、课程号、成绩）course（课程号、课程名、学时数、职工号）stuxx（学号、姓名、性别、年龄、专业）teaxx（职工号、姓名、性别、职称）stuzy（学院名、专业）、建立的五个表及其数据类型如下：表一：stuxxcreate database sgmsgouse sgms create table stuxx(-学号sno varchar(3) not null primary key,-姓名sname varchar(6) not null,-性别ssex varchar(2) not null,-年龄sage smallint,-专业
3、dept varchar(4),)插入数据：insert into stuxxvalues(101,张明,男,20,电信)insert into stuxxvalues(102,王楠,女,21,土木)insert into stuxxvalues(103,黎明,男,19,化工)insert into stuxxvalues(104,淳嫔,女,19,化工)insert into stuxxvalues(875,李丽,女,19,电信)insert into stuxxvalues(111,郭美,女,21,管理)insert into stuxxvalues(117,张灿,女,22,生科)inser
4、t into stuxxvalues(118,李波,男,22,土木)insert into stuxxvalues(123,安宁,男,21,电信)insert into stuxxvalues(128,王海,男,23,电信)insert into stuxxvalues(130,小强,男,16,土木)insert into stuxxvalues(132,保良,男,18,管理)insert into stuxxvalues(113,符强,男,23,生科)insert into stuxxvalues(289,米粒,女,21,化工)insert into stuxxvalues(163,刘雨,女
5、,20,电信)insert into stuxxvalues(164,宇通,男,23,生科)insert into stuxxvalues(178,郭结,女,21,管理)insert into stuxxvalues(190,绿叶,女,21,土木)insert into stuxxvalues(193,安华,男,21,土木)insert into stuxxvalues(152,灿加,男,24,电信)列名数据类型长度字段含义Snovarchar3学生学号Snamevarchar6学生姓名Ssexvarchar2性别Sagesmallint4年龄Deptvarchar4专业表二：teaxxcre
6、ate table teaxx(-教工号tno varchar(3) not null primary key,-姓名tname varchar(4) not null,-性别tsex varchar(2) not null,-职称prof varchar(6),)插入数据：insert into teaxxvalues(001,郭华,男,副教授)insert into teaxxvalues(002,纳迦,男,副教授)insert into teaxxvalues(003,刘阳,女, 助教)insert into teaxxvalues(004,李勇,男, 讲师)insert into te
7、axxvalues(005,李湘,女, 教授)insert into teaxxvalues(006,张三,男,副教授)insert into teaxxvalues(007,李斯,男, 助教)insert into teaxxvalues(008,杨雪,女, 讲师)insert into teaxxvalues(009,马家,男, 教授)insert into teaxxvalues(010,馨予,女, 教授)insert into teaxxvalues(011,小丹,女,副教授)insert into teaxxvalues(012,灿梅,女, 教授)insert into teaxxv
8、alues(013,孙俪,女, 助教)insert into teaxxvalues(014,杨丹,女, 讲师)insert into teaxxvalues(015,周迅,女,副教授)insert into teaxxvalues(016,逸迅,男, 教授)insert into teaxxvalues(017,德华,男,副教授)insert into teaxxvalues(018,品超,男, 助教)insert into teaxxvalues(019,王欢,女,副教授)insert into teaxxvalues(020,李丽,女,副教授)列名数据类型长度字段含义TnoVarchar
9、3教工编号TnameVarchar4教师姓名TsexVarchar2教师性别Profvarchar6教师职称表三：stuzycreate table stuzy(-专业dept varchar(10),-学院coll varchar(10),)insert into stuzyvalues(电信,电气)insert into stuzyvalues(自动化,电气)insert into stuzyvalues(藏物,电气)insert into stuzyvalues(通信,电气)insert into stuzyvalues(制药,化工)insert into stuzyvalues(藏数,
10、计算机)insert into stuzyvalues(岩石力学,土木)insert into stuzyvalues(土建,土木)insert into stuzyvalues(桥梁,土木)insert into stuzyvalues(测绘,土木)insert into stuzyvalues(藏工商,管理)insert into stuzyvalues(统计学,管理)列名数据类型长度字段含义DeptVarchar10专业Collvarchar10学院表四：choosecreate table choose( -学号sno varchar(3) not null references st
11、uxx(sno),-课程号cno varchar(5) not null references course(cno),-成绩degree decimal(4,1)插入数据:insert into choosevalues(101,10001,72)insert into choosevalues(102,10001,88)insert into choosevalues(103,10001,90)insert into choosevalues(104,10001,89)insert into choosevalues(101,10007,89)insert into choosevalue
12、s(875,10005,78)insert into choosevalues(117,10007,90)insert into choosevalues(118,10004,98)insert into choosevalues(123,10007,97)insert into choosevalues(128,10010,54)insert into choosevalues(130,10011,88)insert into choosevalues(132,10013,56)insert into choosevalues(113,10019,77)insert into choosevalues(289,10012,72)insert into choosevalues(163,10015,60)insert into choosevalues(164,10018,75)insert into choosevalues(178,10017,56)insert into choosevalues(190,10020,56)insert into choosevalues(193,10013,59)i
