文件名称：MIS学生信息管理系统
文件大小：2.22MB
文件格式：DOC
更新时间：2014-01-11 06:18:44
管理系统 JAVA项目开发
create table Usermagger ( id int (5)auto_increment primary key, username varchar(20), userpassword varchar(20), studentmaggerrole varchar(10) ) //班级信息表 create table class ( id int (5)auto_increment primary key, deptid int(5), classname varchar(50), classnumber varchar(4), classbeizhu varchar(50) ) alter table class add constraint class unique(id) alter table class add constraint fk_class_deptid foreign key (deptid)references department(id) //老师信息表 create table teacher ( id int (5)auto_increment primary key, tno varchar(5), tname varchar(5), tsex varchar(10), tphone varchar(11), addres varchar(50), brithday Date ) //学生信息表 create table student ( id int (5)auto_increment primary key, stuno varchar(10), stuname varchar(10), stusex varchar(4), stubrithday Date, classid int(5), stutel varchar(11), stuaddres varchar(100) ) alter table student add constraint student unique(stuno) alter table student add constraint fk_student_classid foreign key (classid)references class(id) //学生成绩信息表 create table stugrade ( id int (5)auto_increment primary key, stuno varchar(10), kno varchar(10), grade int(3) )//外键，，需处理 alter table stugrade add constraint fk_stugrade _stuno foreign key (stuno)references student(stuno); );