文档介绍：三、需求规格说明书
三、需求规格说明书
1．引言 1
1
2
2
2
2．任务概述 2
2
2
3
char(3) NOT NULL,
departno char(2) NOT NULL,
departname char(20),
primary key (collegeno,departno)
)
//教师信息
create table teacherinfo(
collegeno char(3) NOT NULL,
departno char(2) NOT NULL,
teacherno char(6) NOT NULL,
teachername char(20),
techtitle char(20),
edubackground char(10),
birthday date,
staffroomno char(2),
isprelect char(1),
primary key(collegeno,departno,teacherno)
)
//教研室信息
create table staffroominfo(
collegeno char(3) NOT NULL,
三、需求规格说明书
departno char(2) NOT NULL,
staffroomno char(2) NOT NULL,
staffroomname char(20),
primary key (collegeno,departno,staffroomno)
)
//不同测评类型包含的测评项目
create table EvalItemByType(
evaltypeno char(10) NOT NULL,
evaltypeitemname char(20) NOT NULL,
evaltypeitemratio int,
evaltypeitemmaxvalue int,
primary key(evaltypeno,evaltypeitemname)
)
//各类测评中各子项目得分统计以后的值
create table evaldatabyevaltype(
semester char(11) NOT NULL,
evalobjno char(20) NOT NULL,
evaltypeno char(10) NOT NULL,
evalvalue int,
evaltperatio int,
primary key(semester,employeeno,evaltypeno)
)
//存储测评的中间结果
create table evaldatabyitem(
semester char(11) NOT NULL,
evalobjno char(20) NOT NULL,
evaltypeno char(10) NOT NULL,
evaltor char(32) NOT NULL,
evalitemname char(20)NOT NULL,
evalitemvalue int,
pri