人力資源數據庫設計計劃書(編輯修改稿)

　

【文章內容簡介】 orkl on worklivefor insert,updateasif (select Emp_id from inserted) not in (select Emp_id from Employee) begin rollback tran raiserror(39。輸入的人員號不存在39。,1,1) endgo（17）創建用戶表create table users(Emp_id int not null ,username varchar(20) ,pwd varchar(10) ,group_id int )go創建用戶表（18）創建外鍵約束觸發器（用戶表）create trigger trg_users on usersfor insert,updateasif (select Emp_id from inserted) not in (select Emp_id from Employee) begin rollback tran 回滾 raiserror(39。輸入的員工號不存在39。,1,1) 報錯 endgo（19）創建模塊表create table module(module_id int identity ,module_name varchar(20),module_pwd varchar(20) )go（20）創建模塊功能分配表create table modulefunc(module_id int not null ,func_id int)go（21）創建功能表create table func(func_id int identity not null ,func_name varchar(20))go（說明：不同的模塊中包含不同的功能，不同層次的員工屬于不同的模塊。比如，普通員工屬于一種模塊，該模塊中只有瀏覽功能。領導類型的員工屬于另一種模塊，該模塊中就有另一部分的功能。以此類推。）三， 測試數據輸入代碼列表（1）培訓管理表數據輸入insert into Train (Title ,Sta_date,End_date,Cont,Person,Memo) values (39。OFFIEC軟件39。,39。2004101839。,39。2004102039。,39。各種OFFIEC軟件的使用39。,39。黃老邪39。,39。優秀39。)insert into Train (Title,Sta_date,End_date,Cont,Person,Memo) values (39。OFFIEC軟件39。,39。2004101839。,39。2004102039。,39。各種OFFIEC軟件的使用39。,39。楊過39。,39。良39。)（2）員工表數據輸入insert into Employee (Emp_name,Gender,Birth,Folk,cid,political,marry,address,spec,school,klevel,tel,,depname,pos,workdate,um,nativeplace) values (39。小龍女39。,39。女39。,39。1980053039。,39。漢39。,39。10000000000139。,39。共產黨39。,39。否39。,39。古墓大街1號39。,39。會計39。,39。古墓大學39。,39。本科39。,39。1111111139。,39。無39。,39。市場部39。,39。員工39。,39。2004101839。,39。100139。,39。中原39。)insert into Employee (Emp_name,Gender,Birth,Folk,cid,political,marry,address,spec,school,klevel,tel,,depname,pos,workdate,um,nativeplace) values (39。楊過39。,39。男39。,39。1982012039。,39。漢39。,39。20000000000239。,39。共產黨39。,39。否39。,39。古墓大街2號39。,39。通訊39。,39。古墓大學39。,39。本科39。,39。2222222239。,39。無39。,39。行政部39。,39。主管39。,39。2004081839。,39。200239。,39。中原39。)insert into Employee (Emp_name,Gender,Birth,Folk,cid,political,marry,address,spec,school,klevel,tel,,depname,pos,workdate,um,nativeplace) values (39。洪七公39。,39。男39。,39。1680041539。,39。漢39。,39。30000000000339。,39。明主黨39。,39。是39。,39。丐幫廣場1號39。,39。經濟39。,39。丐幫學院39。,39。研究生39。,39。3333333339。,39。無39。,39。開發部39。,39。經理39。,39。1993102639。,39。300339。,39。中原39。)insert into Employee (Emp_name,Gender,Birth,Folk,cid,political,marry,address,spec,school,klevel,tel,,depname,pos,workdate,um,nativeplace) values (39。黃老邪39。,39。男39。,39。1698081939。,39。漢39。,39。40000000000439。,39。國民黨39。,39。是39。,39。桃花島1號39。,39。計算機39。,39。桃花島學府39。,39。研究生39。,39。4444444439。,39。無39。,39。開發部39。,39。副經理39。,39。1999082639。,39。400439。,39。海外39。)insert into Employee (Emp_name,Gender,Birth,Folk,cid,political,marry,address,spec,school,klevel,tel,,depname,pos,workdate,um,nativeplace) values (39。黃蓉39。,39。女39。,39。1983091139。,39。漢39。,39。50000000000539。,39。共產黨39。,39。否39。,39。桃花島2號39。,39。人事39。,39。桃花島學府39。,39。本科39。,39。5555555539。,39。無39。,39。人事部39。,39。主管39。,39。2004072639。,39。500539。,39。海外39。)insert into Employee (Emp_name,Gender,Birth,Folk,cid,political,marry,address,spec,school,klevel,tel,,depname,pos,workdate,um,nativeplace) values (39。歐陽鋒39。,39。男39。,39。1670072539。,39?；?9。,39。60000000000639。,39。國民黨39。,39。是39。,39。西域白鴕山小區1號39。,39。經濟39。,39。西域白鴕山大學39。,39。研究生39。,39。6666666639。,39。無39。,39。市場部39。,39。經理39。,39。1992032639。,39。600639。,39。西域39。)（3）部門表數據輸入insert into De