1.效果显示图

2.系统处理过程

3、数据库

create database StudentInfoManagement;use StudentInfoManagement;#建表 #院系表create table Department(Dno char(12),Dname char(12),constraint primary key PK_Department (Dno));#班级表create table Class(Clno char(12),Clname char(12),Dno char(12),constraint primary key PK_Class (Clno),constraint foreign key FK_Class_Department (Dno) references Department(Dno));#学生表create table Student(Sno char(12),Sname char(8),Ssex char(2) check(Ssex in (男，女)，Sage smallint check(Sage > 0),Clno char(12),constraint primary key PK_Student (Sno),constraint foreign key FK_Student_Class (Clno) references Class(Clno));#课程表create table Course(Cno char(12),Cname char(12),Cteacher char(8),Ccredit smallint check(Ccredit > 0),constraint primary key PK_Course (Cno));#选课表create table SC(Sno char(12),Cno char(12),Grade smallint check(Grade < 100 and Grade > 0),constraint foreign key FK_SC_Student (Sno) references Student(Sno),constraint foreign key FK_SC_Course (Cno) references Course(Cno),constraint primary key PK_SC (Sno,Cno));#用户表create table User(username char(12),password char(12) not null,level char(6) check(level in (用户，管理员)，constraint primary key PK_User (username));  #插入测试数据insert into departmentvalues(201501，软件学院)；insert into departmentvalues(201502，经管学院)；insert into departmentvalues(201503，人文学院)；insert into departmentvalues(201504，国际学院)；insert into departmentvalues(201505，理学院)； insert into classvalues#软件学院insert into classvalues#软件学院insert into classvalues#经管学院insert into classvalues#经管学院insert into classvalues#人文学院insert into classvalues('20150302','2015-2班','201503');#人文学院 insert into studentvalues(2015010312，张明，男，20，20150103)insert into studentvalues秦羽，女性，19，20150103；insert into studentvalues('2015010314','刘翔','男',19,'20150103'); insert into coursevalues高等数学，张三，4)；insert into coursevalues('2','数据库原理设计','李四',3);insert into coursevalues('3','Java王五，4)； insert into SCvalues(2015010insert into SCvalues二、二、八十；insert into SCvalues(2015010312，'3'，70)；insert into SCvalues(2015010313，‘1’，90)；insert into SCvalues二、二、八九)；insert into SCvalues('2015010313','3',59);insert into SCvalues(1'，85)insert into SCvalues(2015010314，2'，75)；insert into SCvalues(2015010314，'3'，95)； insert into uservalues('admin666，管理员；insert into uservalues('user，123，用户； #查询示例 ###查询所有课程的平均分#select sc.cno cno,cname,avg(grade) avg#from course,sc#where course.cno = sc.cno#group by cno#order by cno;###查询所有课程不及格率#select cno,(select cname from course where cno = x.cno) cname,
     
      #from sc x
      #group by cno;
      #
      ##查选修某一门课程的总人数
      #select cno,count(Sno) 总人数
      #from SC
      #group by Cno
      #having Cno = '1';
      #
      ##查询某一门课程的全部成绩排名
      #select cno,student.Sno,Dname,Clname,Sname,Ssex,Sage,grade
      #from department,class,student,sc
      #where student.sno = sc.sno
      #and class.Clno = student.Clno
      #and department.Dno = class.Dno
      #and cno = '1'
      #order by grade desc;