員工培訓(xùn)管理系統(tǒng)數(shù)據(jù)庫-資料下載頁
2025-04-17 07:55本頁面
【正文】 create view Tea as select * from Teacher with check optionB、建立存儲(chǔ)（1）不帶參數(shù)的存儲(chǔ)過程：create procedure a_Personalasselect Pername,Cname,Gradefrom Personal p join Grade g on =join course c on =（2）帶參數(shù)的存儲(chǔ)過程：create procedure p_Personal1@sex char(9)asselect Pername,Perdepartment,Cname,Gradefrom Personal p join Grade g on =join course c on =where Persex=@sex（3）帶多個(gè)參數(shù)的存儲(chǔ)過程：create procedure c_Personal@Pername nchar(5),@Cname char(9)=39。高等數(shù)學(xué)39。asselect Pername,Cname,Gradefrom Personal p join Grade g on =join course c on =where Pername=@Pername and Cname=@CnameC、 相應(yīng)功能的查詢操作SELECT * FROM Personal p join Grade g On =附錄：數(shù)字字典數(shù)據(jù)項(xiàng)編號(hào)數(shù)據(jù)項(xiàng)名數(shù)據(jù)項(xiàng)含義與其它數(shù)據(jù)項(xiàng)的關(guān)系存儲(chǔ)結(jié)構(gòu)別名DI1PerNo員工編號(hào)char(9)員工號(hào)DI2PerName員工姓名Nchar(5)姓名DI3PerSex員工性別char(2)性別DI4PerDepartment員工所在部門Number(3)部門DI5Pnumber身份證號(hào)Number(20)身份證號(hào)DI6PerHome籍貫char(20)祖籍DI7PerPhNo聯(lián)系電話char(12)電話DI8PerAdd家庭住址char(20)住址DI9PerNo員工號(hào)char(9)員工號(hào)DI10Cname課程名稱char(9)課程DI11Ctime課程時(shí)間char(10)時(shí)間DI12Cadd課程地點(diǎn)char(10)地點(diǎn)DI13Teacher授課教師char(10)教師DI14Grade成績評(píng)價(jià)Tinyint成績DI15Cno課程號(hào)char(6)課程號(hào)DI16Cname課程名Nvarchar(20）課程DI17CLore課程學(xué)識(shí)Tinyint學(xué)識(shí)DI18Cprepare預(yù)修課程char(9)預(yù)修D(zhuǎn)I19Cdepartment開課部門Nchar(6)開課部門DI20Cbegin初訓(xùn)char(6)初訓(xùn)DI21Crefresh復(fù)訓(xùn)char(6)復(fù)訓(xùn)DI22Wono工作崗位代號(hào)char(9)崗位代號(hào)DI23Woname工作崗位名稱Nvarchar(10）崗位DI24Woright工作崗位權(quán)利Nvarchar(10）權(quán)利DI25Worange工作崗位范圍Nvarchar(10）范圍DI26Deno部門編號(hào)char(9)部門號(hào)DI27Dename部門名稱Nchar(6)部門DI28Demanager部門經(jīng)理Nvarchar(6）經(jīng)理DI29Dassmg部門副經(jīng)理Nvarchar(6）副經(jīng)理DI30Necourse所需培訓(xùn)的課程N(yùn)varchar(20）所需課程DI31Neper要求培訓(xùn)的員工Nchar(5)培訓(xùn)員工DI32Neplan所需培訓(xùn)計(jì)劃Nvarchar(20）培訓(xùn)計(jì)劃DI33TrTbeg培訓(xùn)開始時(shí)間char(10)開始時(shí)間DI34TrTfin培訓(xùn)結(jié)束時(shí)間char(10)結(jié)束時(shí)間DI35Trteacher培訓(xùn)教員char(10)教員DI36Ctime上課時(shí)間 char(10)上課時(shí)間 DI37Cadd上課地點(diǎn)char(10)上課地點(diǎn)DI38Trteacher培訓(xùn)員char(10)培訓(xùn)員DI39Trcourse培訓(xùn)課程N(yùn)varchar(20）培訓(xùn)課程DI40Cname課程名Nvarchar(20）課程DI41Evacontent評(píng)價(jià)內(nèi)容Nvarchar(20）評(píng)價(jià)DI42Evatime評(píng)價(jià)時(shí)間char(10)評(píng)價(jià)時(shí)間DI43Teno教員號(hào)char(10)教員號(hào)DI44Tename教員姓名char(10)教員DI45Teeducation教員學(xué)歷char(10)學(xué)歷DI46Tetime開始教學(xué)時(shí)間char(10)教學(xué)時(shí)間DI47Teeva教員評(píng)價(jià)Nvarchar(20)評(píng)價(jià)（b）數(shù)據(jù)結(jié)構(gòu)：數(shù)據(jù)結(jié)構(gòu)編號(hào)數(shù)據(jù)結(jié)構(gòu)名數(shù)據(jù)結(jié)構(gòu)含義組成DS1Personal員工信息PerNo,PerName,PerSex,PerDepartment,Pnumber,PerHome,PerPhNo,PerAdd,gradeDS2Grade員工培訓(xùn)成績PerNo,Cno,GradeDS3Course課程信息Cname,Ctime,Cadd,Teacher,Grade,Cno,Cname,CLore,Cprepare,Cdepartment,Cbegin,CrefreshDS4Work工作信息Wono,Woname,Woright,WorangeDS5Department部門信息Deno,Dename,Demanager,DassmgDS6Need需求信息Necourse,Neper,NeplanDS7Train培訓(xùn)信息TrTbeg,TrTfin,Trteacher,TrcourseDS8Evaluate評(píng)價(jià)信息Evacontent,Evatime,Cno,TenoDS9Teacher教員信息Teno,Tename,Teeducation,Tetime,Teeva29 / 29
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1