人事管理系统的设计数据库课程设计

is responsible for Organization training, and implementation, and check; 12, master workshops annual economic indicators of implementation, reporting to financial health on a regular basis; 13, is responsible for the daily oversight in the allocation and use of funds; 14, responsible for all Department statistics, collecting, sorting, reporting of accounting reports; 15, the company responsible for the supervision of the Treasury, including the \d grade\y, a library of materials, products for regular inventory handling, sampling, storage monitoring, the picking work, and provide the inventory report, and make the appropriate accounting treatment; 16, responsible for waste and recycling, transportation and settlement; 17, is responsible for all product sales accounting functions; 18, responsible for the company's raw materials, auxiliary materials, account management; 19, is responsible for the flow of control of all assets of the company, according to the changes in accounting treatment of fixed assets and assets to the departments responsible for clearing, settlement and asset monthly report submitted to the asset management section of the Finance Department of the company organized on a company-wide special inspection of asset management; 20, according to the company's business activities, monthly projects involved in the business activities of the company (including expenses, business management, cost control, cash flow, revenue, etc) financial analysis, provide a basis for decisions for the company, the business of the company responsible for monitoring, forecasting and risk analysis; 21, responsible for the settlement of transactions with the Bank; 22, is 用户需求分析

人事管理系统系是为了更好的实现人事各种信息的管理以及各种信息的安全性管理。本系统主要对查看员工的各种信息需求所设计的,可以很好的管理数据。 本系统的主要功能由以下几个部分组成:

员工基本信息模块输入:员工信息功能:对员工基本信息的查询、修改、删除和查询。

员工工资管理模块输入:员工工资情况功能:完成对员工工资的修改、查询,统计员工基本信息表。

员工考勤管理模块输入:员工考勤情况功能:完成对员工考勤情况的查询、删除员工考勤等情况。

员工工资信息表和员工考勤信息表和员工基本信息表是相似的。查询模块是指在建表的基础上,用户对所需要的资料的查询。包括单一条件查询和多条件查询。从查询对象来看,又可分为对员工基本信息的查询和对员工工资信息、员工考勤信息的查询。

员工身份的确认:只有用户名和用户密码都相符的用户方可进入本系统,为了防止不合法用户对数据的察看和修改,本系统把用户分为三个级别:员工和管理员,员工包括管理员不仅拥有对数据的查询、统计、打印权限,还对用户的使用权限进行控制,管理员可以设定用户名、密码和其权限,还可以对纪录进行增加、删除、修改等操作。当用户要进入系统时必须先输入用户名和密码,按“确认”按钮后,系统辨别用户身份,对合法用户根据用户的权限赋予相应的使用功能。

系统功能主要分为以下四个模块:员工管理、工资管理、部门管理、系统管理。

以下分别对员工管理、工资管理、部门管理、系统管理的四个模块进行详细的描述介绍。

is responsible for Organization training, and implementation, and check; 12, master workshops annual economic indicators of implementation, reporting to financial health on a regular basis; 13, is responsible for the daily oversight in the allocation and use of funds; 14, responsible for all Department statistics, collecting, sorting, reporting of accounting reports; 15, the company responsible for the supervision of the Treasury, including the \d grade\y, a library of materials, products for regular inventory handling, sampling, storage monitoring, the picking work, and provide the inventory report, and make the appropriate accounting treatment; 16, responsible for waste and recycling, transportation and settlement; 17, is responsible for all product sales accounting functions; 18, responsible for the company's raw materials, auxiliary materials, account management; 19, is responsible for the flow of control of all assets of the company, according to the changes in accounting treatment of fixed assets and assets to the departments responsible for clearing, settlement and asset monthly report submitted to the asset management section of the Finance Department of the company organized on a company-wide special inspection of asset management; 20, according to the company's business activities, monthly projects involved in the business activities of the company (including expenses, business management, cost control, cash flow, revenue, etc) financial analysis, provide a basis for decisions for the company, the business of the company responsible for monitoring, forecasting and risk analysis; 21, responsible for the settlement of transactions with the Bank; 22, is员工管理

查看选中员工的详细资料,员工资料又分为基本资料和高级资料。 基本资料

员工编号、员工姓名、性别、出生日期、身份证号、婚姻状况、民族、

机关、政治面貌、电子邮箱、联系电话、联系地址、部门、职位、职称、基本工资、聘用形式、最高学历、所属专业、毕业院校、入职日期、在职状态、工号、合同期限。 高级资料

(1).奖惩资料:奖惩日期、奖惩分数、奖惩原因。 (2).培训资料:培训日期、培训内容。

(3).考评资料:考评日期、考评内容、考评结果。

(4).调薪资料:调薪日期、调前薪资、调后薪资、调薪原因。

(5).调动资料:调动日期、调前部门、调前职位、调动原因、调后部门、

调后职位、备注。

(6).其他信息:管理员可任意备注其他信息。 工资管理

实现对员工工资账套管理、员工账套设置、工资表管理、月末处理、工资表查询一系列对员工工资管理的功能。

系统管理

对系统、管理员等一些操作,包括基础信息设置、系统管理、操作员管理、备份恢复数据、初始化数据库。 基础信息设置

1

is responsible for Organization training, and implementation, and check; 12, master workshops annual economic indicators of implementation, reporting to financial health on a regular basis; 13, is responsible for the daily oversight in the allocation and use of funds; 14, responsible for all Department statistics, collecting, sorting, reporting of accounting reports; 15, the company responsible for the supervision of the Treasury, including the \d grade\y, a library of materials, products for regular inventory handling, sampling, storage monitoring, the picking work, and provide the inventory report, and make the appropriate accounting treatment; 16, responsible for waste and recycling, transportation and settlement; 17, is responsible for all product sales accounting functions; 18, responsible for the company's raw materials, auxiliary materials, account management; 19, is responsible for the flow of control of all assets of the company, according to the changes in accounting treatment of fixed assets and assets to the departments responsible for clearing, settlement and asset monthly report submitted to the asset management section of the Finance Department of the company organized on a company-wide special inspection of asset management; 20, according to the company's business activities, monthly projects involved in the business activities of the company (including expenses, business management, cost control, cash flow, revenue, etc) financial analysis, provide a basis for decisions for the company, the business of the company responsible for monitoring, forecasting and risk analysis; 21, responsible for the settlement of transactions with the Bank; 22, is对部门、职位、职称、奖惩规则和权限组的设置管理,及其个项目的增删改查。 数据字典: 1. 数据项

员工信息数据字典

编号 数据项名称 说 明 部 编号 数据项名称 说 明 部 分 1 员工编号 字符串类型 有唯2 一性 3 性别 字符串类型 男、4 女 5 员工参加工作时时间类型 **/** 间 7 所属部门编号 字符串类型 有唯8 一性 9 联系电话 字符串类型 有唯10 一性 11 办公电话 字符串类型 有唯12 一性 13 15

分 姓名 字符串类型 长度为20字符 年龄 整数类型 18-100 6 民族 字符串类型 有唯一性 身份证号 字符串类型 有唯一性 E-mail 字符串类型 有唯一性 教育程度 字符串类型 专业 外语水平 字符串类型 字符串类型 14 16 毕业学校 字符串类型 计算机水平 字符串类型 2

联系客服:779662525#qq.com(#替换为@) 苏ICP备20003344号-4