數據庫課程設計企業(yè)人事管理信息系統(tǒng)畢業(yè)論文-資料下載頁
2025-06-22 14:40本頁面
【正文】 DepId In (select DepId from tbDep where DepId=39。0609020239。 )。運行結果為：二、源程序清單“CPD”CREATE SCHEMA“CPD” AUTHORIZATION XDAPING2. 創(chuàng)建用戶編碼信息表格tbUserCREATE TABLE CPD . tbUser (UserId CHAR(10) NOT NULL,UserPassword CHAR (8) NOT NULL,UserKind CHAR (20) NOT NULL,PRIMARY KEY (UserId))。3. 創(chuàng)建職務編碼信息表格tbDutyCREATE TABLE CPD . tbDuty (DutyId CHAR(8) NOT NULL,DutyName CHAR (20) NOT NULL,PRIMARY KEY (DutyId))。4. 創(chuàng)建文化程度編碼信息表格tbEduCREATE TABLE CPD .tbEdu(Eduld CHAR(2) NOT NULL,EduName CHAR (20) NOT NULL,PRIMARY KEY (Eduld))。5. 創(chuàng)建民族編碼信息表格tbNationCREATE TABLE CPD . tbNation (NationId CHAR(3) NOT NULL,NationName CHAR (20) NOT NULL,PRIMARY KEY (NationId))。5. 創(chuàng)建部門編碼信息表格tbDepCREATE TABLE CPD . bDep (DepId CHAR(8) NOT NULL,DepName CHAR(30) NOT NULL,Describe CHAR (100) NOT NULL,PRIMARY KEY (DepId、DepName))。6. 創(chuàng)建職員家庭信息表格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. 創(chuàng)建職員基本信息表格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. 創(chuàng)建職員月考勤信息表格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經手人發(fā)行商日歷訂購31 館藏圖書2 訂購庫3 訂單庫4 記賬驗收4驗收登記5催詢65 進書庫2 訂購庫4 記賬日歷驗收人編目子系統(tǒng)圖書館采編系統(tǒng) 采編系統(tǒng)結構圖圖書編目查重著錄編目修改編目注銷圖書檢索登錄號ISBN編著者/出版社書 名索書號圖書采購*采購記賬*新書催詢進書驗收圖書訂購退出系統(tǒng)藏書統(tǒng)計*圖書卡片**新書通告**書本式目錄*書標帖*圖書財產目錄
法律信息相關推薦
鄂ICP備17016276號-1