【文件属性】:
文件名称: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);
);