數據庫課程設計企業人事管理信息系統畢業論文-資料下載頁

　　

【正文】 DepId In (select DepId from tbDep where DepId=39。0609020239。 )。運行結果為：二、源程序清單“CPD”CREATE SCHEMA“CPD” AUTHORIZATION XDAPING2. 創建用戶編碼信息表格tbUserCREATE TABLE CPD . tbUser (UserId CHAR(10) NOT NULL,UserPassword CHAR (8) NOT NULL,UserKind CHAR (20) NOT NULL,PRIMARY KEY (UserId))。3. 創建職務編碼信息表格tbDutyCREATE TABLE CPD . tbDuty (DutyId CHAR(8) NOT NULL,DutyName CHAR (20) NOT NULL,PRIMARY KEY (DutyId))。4. 創建文化程度編碼信息表格tbEduCREATE TABLE CPD .tbEdu(Eduld CHAR(2) NOT NULL,EduName CHAR (20) NOT NULL,PRIMARY KEY (Eduld))。5. 創建民族編碼信息表格tbNationCREATE TABLE CPD . tbNation (NationId CHAR(3) NOT NULL,NationName CHAR (20) NOT NULL,PRIMARY KEY (NationId))。5. 創建部門編碼信息表格tbDepCREATE TABLE CPD . bDep (DepId CHAR(8) NOT NULL,DepName CHAR(30) NOT NULL,Describe CHAR (100) NOT NULL,PRIMARY KEY (DepId、DepName))。6. 創建職員家庭信息表格tbFamilyMemberCREATE TABLE CPD . tbFamilyMember (Id CHAR(8) NOT NULL,EmpId CHAR (8) NOT NULL,Name CHAR(30) NOT NULL,Gender CHAR (2) NULL,Age CHAR(4) NULL,Relationship CHAR (20) NULL,WorkingOrg CHAR(50) NULL,PRIMARY KEY (Id))。7. 創建職員基本信息表格tbEmployeeCREATE TABLE CPD . tbEmployee (EmpId CHAR(8) NOT NULL,EmpName CHAR (30) NOT NULL,Gender CHAR(2) NOT NULL,Age CHAR (4) NOT NULL,NationId CHAR(3) NOT NULL,Birthday CHAR (8) NOT NULL,PoliticalParty CHAR(20) NOT NULL,MaritalCon CHAR (6) NOT NULL,DepId CHAR(8) NOT NULL,HireDate CHAR (8) NOT NULL,Eduld CHAR(2) NOT NULL,FamilyPlace CHAR(20) NOT NULL,IdCard CHAR(20) NOT NULL,Email CHAR(30) NOT NULL,Officephone CHAR(20) NOT NULL,State CHAR(20) NOT NULL,Residence CHAR (100) NOT NULL,Postcode CHAR (8) NOT NULL,PRLocation CHAR (50) NOT NULL,PRIMARY KEY (EmpId，IdCard，Email))。8. 創建職員月考勤信息表格tbWorkRecordCREATE TABLE CPD . tbWorkRecord (RecordTime CHAR(8) NOT NULL,EmpId CHAR (8) NOT NULL,DepId CHAR(30) NOT NULL,LeaveDays CHAR (2) NULL,AbsentDays CHAR(4) NULL,OtDays CHAR (20) NULL,workingDays CHAR(50) NULL,PRIMARY KEY (RecordTime))。征訂目錄預訂信息訂購單 采購數據流圖 進書單驗收信息進書信息訂購通知催詢單查重選訂1預訂登記2經手人發行商日歷訂購31 館藏圖書2 訂購庫3 訂單庫4 記賬驗收4驗收登記5催詢65 進書庫2 訂購庫4 記賬日歷驗收人編目子系統圖書館采編系統 采編系統結構圖圖書編目查重著錄編目修改編目注銷圖書檢索登錄號ISBN編著者/出版社書 名索書號圖書采購*采購記賬*新書催詢進書驗收圖書訂購退出系統藏書統計*圖書卡片**新書通告**書本式目錄*書標帖*圖書財產目錄