高校人力資源管理系統(tǒng)(參考版)
2025-05-18 03:05本頁面
【正文】 Information Technology, 編輯部郵箱 2021 年 Z1期 [5]Visual Basic 數(shù)據(jù)庫開發(fā)與專業(yè)應(yīng)用 于英杰編著 北京 :國防工業(yè)出版社 。 通過本次數(shù)據(jù)庫課程設(shè)計，對數(shù)據(jù)庫的相關(guān)知識得到了進一步的學(xué)習(xí)和理解，同時也把所學(xué)的數(shù)據(jù)庫知識進行了一次梳理，對數(shù)據(jù)庫這門課程的理解有了很大提高，同時利用這種模擬實際問題的課程設(shè)計，對我們的動手能力，考慮問題的嚴(yán)密性都有很大幫助，相信對今后工作會有很大幫助。 with replace go create trigger tr2 on yuangong for update as begin declare bumenbianhaoold char(10),bumenbianhaonew char(10) select bumenbianhaoold=bumenbianhao from deleted select bumenbianhaonew=bumenbianhao from inserted update bumen set bumenrenshu=bumenrenshu1 where bumenbianhao=bumenbianhaoold update bumen set bumenrenshu=bumenrenshu+1 where bumenbianhao=bumenbianhaonew end 八 ，實驗總計 在本次數(shù)據(jù)庫課程設(shè)計中，主要完成了利用存儲過程和觸發(fā)器對系統(tǒng)信息的修改、刪除、添加等功能，主要完成了觸發(fā)器修改系統(tǒng)信息時同步修改系統(tǒng)內(nèi)其他相關(guān)信息，基本完成了實驗要求。 go use master go restore database renli from disk=39。where bumenrenshu=39。 with init go use renli go update bumen set bumenrenshu =39。 ，建立數(shù)據(jù)庫相關(guān)表之間的參照完整性約束 use renli go alter table zonghe with nocheck add constraint fk_a foreign key (bumenbianhao) references bumen(bumenbianhao) on delete cascade go use renli go alter table zonghe with nocheck add constraint fk_b foreign key (yuangongbianhao) references yuangong(yuangongbianhao) on delete cascade go use renli go alter table zonghe with nocheck add constraint fk_c foreign key (zhichengbianhao) references zhicheng(zhichengbianhao) on delete cascade go use renli go alter table zonghe with nocheck add constraint fk_d foreign key (guanliyuanbianhao) references guanliyuan(guanliyuanbianhao) on delete cascade go use renli go alter table zonghe with nocheck add constraint fk_e foreign key (jiangfabianhao) references jiangcheng(jiangfabianhao) on delete cascade go use renli go alter table zonghe with nocheck add constraint fk_f foreign key (zhuanye) references xueli(zhuanye) on delete cascade go ，數(shù)據(jù)庫簡單備份和還原 use renli go backup database renli to disk=39。)is not null drop trigger tri_5 go create trigger tri_5 on bumen for update as begin if (update(bumenbianhao)) update zonghe set =(select bumenbianhao from inserted) where =(select bumenbianhao from deleted) end ，創(chuàng)建規(guī)則用于保證教職工的 EMail 的輸入格式正確 use renli go create rule E_mail_rule as =39。,39。 use renli go if object_id (39。tr39。tri_439。)is not null drop trigger tri_3 go create trigger tri_3 on yuangong for delete as begin update bumen set bumenrenshu=bumenrenshu1 where bumenbianhao in (select bumenbianhao from deleted) end 觸發(fā)器 tri_4:要求員工信息表中的員工編號被修改時， 綜合信息表中的員工編號也被修改。,39。)is not null
黨政相關(guān)相關(guān)推薦
鄂ICP備17016276號-1