【免费下载】 宿舍管理系统数据字典

一、引言..............................................................................................................................................3

1.1编写目的................................................................................................................................31.2背景........................................................................................................................................31.3定义........................................................................................................................................31.4参考资料................................................................................................................................3二、数据结构......................................................................................................................................3

2.1、用户信息结构.....................................................................................................................32.2、住宿学生信息结构.............................................................................................................42.3、宿舍信息结构.....................................................................................................................42.4、宿舍财产信息结构.............................................................................................................42.5、报修信息结构.....................................................................................................................52.6、夜归信息结构.....................................................................................................................52.7、离校学生信息.....................................................................................................................5三、数据表设计..................................................................................................................................6

3.1住宿学生数据字典................................................................................................................6

表名：stuDorm....................................................................................................................63.2、宿舍数据字典.....................................................................................................................6

表名：dorm.........................................................................................................................63.3、宿舍财产数据字典.............................................................................................................7

表名：dorPro.......................................................................................................................73.4、报修数据字典.....................................................................................................................7

表名：dorRepair..................................................................................................................73.5、晚归数据字典.....................................................................................................................7

表名：dorLate.....................................................................................................................73.6、离校数据字典.....................................................................................................................7

表名：dorLeave...................................................................................................................73.7、用户数据字典.....................................................................................................................7

表名：dorUsers...................................................................................................................7

四、数据流程......................................................................................................................................8

4.1、报修数据流图.....................................................................................................................84.2、离返校数据流图.................................................................................................................84.3、晚归数据流图.....................................................................................................................94.4、总数据流图.........................................................................................................................9

第 2 页 共 10 页

1.3定义1.2背景1.1编写目的一、引言1.4参考资料二、数据结构用户信息用户密码第 3 页 共 10 页2.1、用户信息结构用户ID用户类型宿舍财产信息性别专业宿舍信息2.4、宿舍财产信息结构学号入住时间姓名住宿学生信息宿舍电话宿舍号第 4 页 共 10 页2.3、宿舍信息结构2.2、住宿学生信息结构宿舍号2.7、离校学生信息宿舍号解决日期报修原因提交日期物品号物品号2.6、夜归信息结构2.5、报修信息结构报修信息物品名晚归原因宿舍号离校学生信息夜归学生信息返回时间第 5 页 共 10 页晚归时间学号宿舍号离校时间学号3.4、报修数据字典专业性别姓名学号3.2、宿舍数据字典表名：dorm3.1住宿学生数据字典宿舍电话入住时间3.3、宿舍财产数据字典表名：dorPro表名：stuDorm物品名宿舍号属性名宿舍号属性名物品号属性名三、数据表设计表名：dorRepairSdeptPnoSnoSsexDnoDno第 6 页 共 10 页Scheckin字段名DphonePnameSname字段名字段名date类型类型Varchar2Varchar2Varchar2Varchar2Varchar2Varchar2Varchar264640202015长度长度主键约束主键约束Not nullNot nullNot nullNot nullNot nullNot null类型numberVarchar22长度20主键约束Not null学号属性名宿舍号属性名学号用户ID3.7、用户数据字典3.6、离校数据字典3.5、晚归数据字典用户类型物品号宿舍号离校时间报修原因解决日期提交日期宿舍号属性名表名：dorLate用户密码晚归原因晚归时间表名：dorLeave属性名返回时间表名：dorUsersSnoDnoDnoPno字段名字段名LreturnUnameRreasonRsubmitUpasswordBreasonrLtimeSnoDno字段名BtimeUtype类型date 类型Varchar2Varchar2Varchar2timestampVarchar2Varchar2Varchar22086506101420长度长度外键外键约束外键外键约束Not nullNot null字段名Rsolve第 7 页 共 10 页datedatenumber类型类型Varchar2Varchar2Varchar2Varchar2Varchar28886长度长度202020外键外键约束Not nullNot nullNot null主键约束Not nullNot null属性名退宿原因退宿时间学生学号4.1、报修数据流图四、数据流程3.8、学生退宿数据字典表名：quitDor第 8 页 共 10 页4.2、离返校数据流图字段名SnoquitTimequitWhydateNot null类型长度20外键约束Varchar24.4、总数据流图

第 9 页 共 10 页

4.3、晚归数据流图

第 10 页 共 10 页