人事管理系统规划_ECW.docVIP

概述：··························································3 需求分析：··················································3 1．1用户需求··············································3 1．2业务流程分析··········································3 1．3信息需求分析··········································4 1．3．1资料收集·········································5 1．3．2事项（数据项）分析·······························6 1．4功能需求··············································7 二、数据库概念模型设计：········································8 初始ERD················································8 改进ERD················································9 数据库逻辑模型设计·········································10 3．1一般逻辑模型设计——ERD转换为一般关系模型···············10 3．2、具体逻辑模型设计········································12 ――把一般关系模型转换成具体DBMS支持的逻辑结构 数据库物理设计与数据文件保护设计···························16 4．1设计索引·················································16 4．2设计表间关系·············································16 4．3完整性设计···············································16 五、处理功能设计：··············································17 5．1主控模块设计·············································17 5．2子模块设计···············································19 5．2．1设计输入············································19 5．2．2视图设计·············································20 5．2．3查询设计·············································21 5．2．4报表设计·············································21 六、数据库应用系统的实现：·······································22 6．1数据库及其表结构的建立····································22 6．2数据输入··················································27 6．3模块实现：·················································28 经过与体会···················································32 七、数据库应用系统运行：········································32 7．1系统操作使用的简要说明···································32 7．2按使用说明运行系统并打印出运行结果···················33 7．3系统评价··················································37 概述： 海富制衣厂根据业务需要，确定开发一个“人事管理系统”，以取代现在的完全人工管理。开发的基本目标包括：员工个人资料的录入、部门