【正文】 [int] references Dept(DeptId) NOT NULL, [PastDept] [int] references Dept(DeptId)NOT NULL, [PresentPosition] [int] references Position(PositionId)NOT NULL, [PastPosition] [int] references Position(PositionId)NOT NULL, [TransfeTime] [datetime] NOT NULL, [TransferReason] [nchar](100))//建立缺員表CREATE TABLE [dbo].[LackPosition]( [LackPositionId] [int] identity(1,1) primary key NOT NULL, [DeptId] [int] references Dept(DeptId) NOT NULL, [LackPosition] [int] references Position(PositionId) NOT NULL, [LackQuantity] [nchar](20) NOT NULL, [OtherRequire] [nchar](100) NULL)//建立招聘記錄表create table [dbo].[RecuitRecord]( [RecordId] [int] identity(1,1) primary key not null, [RecruitTime] [datetime] not null, [DeptId] [int] references Dept(DeptId) not null, [NeedQuantity] [int] not null, [Remark] [nchar](200))//建立培訓(xùn)記錄表create table [dbo].[TrainRecord]( [RecordId] [int] identity(1,1) primary key not null, [ItemId] [int] references TrainItem(TrainId) not null, [JoinQuantity] [nchar](30), [Remark ] [nchar](200))//建立應(yīng)聘者信息表CREATE TABLE [dbo].[Interviewer]( [InterviewerId] [int] IDENTITY(1,1) NOT NULL, [InterviewerName] [nchar](20) NOT NULL, [InterDept] [int] references Dept(DeptId) NOT NULL, [InterPosition] [int] references Category(CategoryId) NOT NULL, [Speciality] [nchar](30) NOT NULL, [Sex] [int] references CategoryInfo(CategoryId) NOT NULL, [Education ] [int] references CategoryInfo(CategoryId) NOT NULL, [IdCardNo] [nchar](20) NOT NULL, [MobilePhone] [nchar](20) NOT NULL, [TelPhone] [nchar](20) NULL, [] [nchar](10) NULL, [Email] [nchar](30) NULL, [Remark] [nchar](200) NULL )//建立員工駕證信息表create table [dbo].[CertificateInfo]( [CertificateId] [int] identity(1,1) primary key not null, [StaffId] [int] references Staff(StaffId)not null, [CeQuantity] [int] , [Remark] [nchar](200) )//建立員工家庭情況表create table [dbo].[FamilyInfo]( [FamilyId ] [int] identity(1,1) primary key not null, [StaffId] [int] references Staff(StaffId) not null, [SpouseName] [nchar](20), [Telephone] [nchar](20), [ChildQuantity] [int])//建立員工住宿情況表create table [dbo].[InhabitInfo]( [InhabitId] [int] identity(1,1) primary key not null, [StaffId] [int] references Staff(StaffId) not null, [InhabitOrNot] [nchar](2) not null, [RoomNo] [int] ) //建立部門經(jīng)理列表create table [dbo].[DeptManager]( [DeMaId] [int] identity(1,1) primary key not null, [DeptId] [int] references Dept(DeptId) not null, [StaffId] [int] references Staff(StaffId) not null)//建立加薪升職統(tǒng)計(jì)表create table [dbo].[IncreasePromotion]( [InPrId] [int] identity(1,1) primary key not null, [StaffId] [int] references Staff(StaffId) not null, [IncreaseOrNot] [nchar](2), [Promotion] [nchar](2) , [Remark] [nchar](200) )//建立業(yè)務(wù)考核統(tǒng)計(jì)表create table [dbo].[Business]( [BusinessId] [int] identity(1,1) primary key not null, [StaffId] [int] references Staff(StaffId) not null, [AssignQuantity] [nchar](30) not null, [ReachQuantity] [nchar](30) not null, [Remark] [nchar](200) )//建立考勤表create table [dbo].[Attendence]( [AttendenceId] [int] identity(1,1) primary key not null, [StaffId] [int] references Staff(StaffId) not null, [AbsenceTime] [datetime], [AbsenceCategory] [int] references CategoryInfo(CategoryId))//建立自動(dòng)提醒列表create table [dbo].[Attention]( [AttentionId] [int] identity(1,1) primary key not null, [AttentionCategory] [int] references CategoryInfo(CategoryId), [StaffId] [int] references Staff(StaffId) not null, [Remark] [nchar](100))//建立工資表create table [dbo].[Salary]( [SalaryId] [int] identity(1,1) primary key not null, [StaffId] [int] references Staff(StaffId) not null, [BasicSalary] [int] not null, [Prize] [int] not null, [TimingSalary] [int] not null, [PieceSalary] [int] not null, [Welfare] [int] not null, [Insurance] [int] not null, [Tax] [int] not null, [Sum] [int] not null)（備注：由于時(shí)間及小組人員技術(shù)問題，部分表格可能無法實(shí)現(xiàn)，如：考勤表、工資表、績效考勤表在此僅做最基本的功能實(shí)現(xiàn)，若是時(shí)間允許將做進(jìn)一步改善。輸出：→D1輸入：系統(tǒng)管理員→處理：系統(tǒng)管理員輸入用戶名跟密碼后，查找用戶信息表是否存在此輸入的數(shù)據(jù)，若存在則讓用戶登錄系統(tǒng)，否則返回重新登錄。由于該系統(tǒng)能以較低的成本，較短的時(shí)間開發(fā)出來，且能極大地提高員工信息查詢、報(bào)表查詢等方面的功能，必然能得到廣大員工和領(lǐng)導(dǎo)的支持。系統(tǒng)代碼開發(fā)費(fèi)用，開發(fā)用的場地，計(jì)算機(jī)，網(wǎng)絡(luò)環(huán)境等。1規(guī)范企業(yè)管理，實(shí)現(xiàn)對全公司人事管理的實(shí)時(shí)監(jiān)控。本分析報(bào)告是為項(xiàng)目開發(fā)者、投資者、領(lǐng)導(dǎo)，以及參與實(shí)施本項(xiàng)目的工作者作參考，為了方便公司的人事管理。3) 人事管理：這一系統(tǒng)包含員工檔案管理、部門管理、調(diào)動(dòng)管理、合同管理、培訓(xùn)管理、績效考評管理這幾個(gè)子模塊。使用軟件時(shí)，企業(yè)員工只需登錄便能查詢、瀏覽他所需要的信息。2) 實(shí)現(xiàn)對每名員工個(gè)人業(yè)績的考核。 本系統(tǒng)是對公司的人事資料進(jìn)行管理，為人事管理人員提供了一套簡單的操作、使用可靠、界面友好、易于管理和使用的處理工具。北京理工大學(xué)珠海學(xué)院《課程設(shè)計(jì)》人事管理系統(tǒng)分析與設(shè)計(jì)學(xué) 院： 管理與經(jīng)濟(jì)學(xué)院 專 業(yè)： 信息管理與信息系統(tǒng) 班 級： 4班 組 長： 周東如 其他成員：黎佩明、鄭東梅、張維佳目錄一、 任務(wù)安排二、 整體規(guī)劃三、 需求分析報(bào)告四、 可行性分析報(bào)告五、 業(yè)務(wù)流程圖六、 數(shù)據(jù)流程圖七、 結(jié)構(gòu)圖八、 數(shù)據(jù)字典九、 ER圖十、