數(shù)據(jù)庫學(xué)生管理系統(tǒng)-資料下載頁
2025-04-07 23:10本頁面
【正文】 om teacherswhere teachername=@teacherendgo用戶請輸入：declare @x char(10),@y char(20),@z char(10)exec teacherproc 39。請輸入您要查找的老師姓名39。,@x output,@y output,@z outputselect @x,@y,@z6） 創(chuàng)建觸發(fā)器(1)觸發(fā)器ctrigger：要求學(xué)生選課課程表中的課程號被刪除時(shí)，學(xué)生選課成績表中的對應(yīng)的課程號的信息也被刪除。create trigger ctrig on course after deleteasbegindelete SC where o in(select o from deleted)End用戶輸入：delete C where o=(輸入您要刪除的課程號)（2）觸發(fā)器strigger：要求學(xué)生信息表中的學(xué)號被修改時(shí)，學(xué)生選課成績表、學(xué)生公共課成績表中的學(xué)號自動修改。create trigger ctrig on student after updateasbeginupdate selectcourse set sno in(select sno from inserted)where sno in(select sno from deleted)end用戶輸入：update student set sno=39。請輸入您要修改的新學(xué)號39。 wheresno=39。請輸入該學(xué)生的舊學(xué)號39。 （３）觸發(fā)器ttrigger：要求教師信息表中老師的職工號修改，則教師選課信息的職工號也會被修改create trigger ttrig on teachers after updateasbeginupdate teachercourse set teacherID in(select teacherID from inserted)where teacherID in(select teacherID from deleted)end用戶輸入：update teachers set teacherID=39。請輸入您要修改的新職工號39。 whereteacherID=39。輸入原來的舊職工號39。（４）觸發(fā)器 ttrigger：要求若輸入的學(xué)號或者課程號與數(shù)據(jù)庫中數(shù)據(jù)不符則不插入選課成績表中create trigger check_trigon selectcourse after insertasbeginif exists(select * from inserted where sno not in(select sno from s) or o not in(select o from course))rollbackendgo用戶輸入：insert selectcourse values(39。輸入學(xué)生的學(xué)號39。,39。輸入學(xué)生選修的課程號39。,39。輸入該門成績39。)（5）觸發(fā)器insert_student:如果學(xué)生表中有新的學(xué)生插入，則觸發(fā)該觸發(fā)器，使得該學(xué)生信息插入create trigger insert_student on studentafter insertasbegininsert into student values(39。sno39。,39。studentname39。,39。sex39。,39。sage39。,39。collegename39。,39。majorname39。,39。grade39。,39。class39。,39。tel39。)End（6）觸發(fā)器insert_classes:如果有新的班級被添加，則觸發(fā)該觸發(fā)器使得該班級信息添加進(jìn)來create trigger insert_classes on classesafter insertasbegininsert into classes values(39。class39。,39。grade39。,39。collegename39。,39。majorname39。)end（7）觸發(fā)器insert_college:如果有新的學(xué)院被添加，則觸發(fā)該觸發(fā)器使得該學(xué)院信息添加進(jìn)來create trigger insert_college on collegeafter insertasbegininsert into college values(39。collegename39。,39。collegeID39。)end(8)觸發(fā)器insert_course:如果有新的課程被添加，則觸發(fā)該觸發(fā)器使得該課程相關(guān)信息添加進(jìn)來create trigger insert_course on courseafter insertasbegininsert into course values(39。o39。,39。coursename39。,39。collegename39。,39。credit39。)end（9）觸發(fā)器insert_depart:如果有新的教師研究室被添加，則觸發(fā)該觸發(fā)器使得該教師研究室的相關(guān)信息添加進(jìn)來create trigger insert_depart on departafter insertasbegininsert into depart values(39。department39。,39。departID39。,39。collegename39。)end（10）觸發(fā)器insert_major:如果有新的專業(yè)被添加，則觸發(fā)該觸發(fā)器使得該專業(yè)的相關(guān)信息被添加進(jìn)來create trigger insert_major on majorafter insertasbegininsert into major values(39。majorname39。,39。majorID39。,39。collegename39。)end(11)觸發(fā)器insert_selectcourse:如果有某位同學(xué)新選的課程需要添加進(jìn)來，則觸發(fā)該觸發(fā)器使得該學(xué)生選擇的這門課程的相關(guān)信息被添加進(jìn)來create trigger insert_selectcourse on selectcourseafter insertasbegininsert into selectcourse values(39。sno39。,39。o39。,39。teacherID39。,39。score39。)end 77(12)觸發(fā)器insert_teachercourse:如果有某位教師的選課信息要添加，則觸發(fā)該觸發(fā)器使得相關(guān)信息被添加進(jìn)來create trigger insert_teachercourse on teachercourseafter insertasbegininsert into teachercourse values(39。o39。,39。coursename39。,39。teacherID39。)end (13)觸發(fā)器insert_teachers:如果有新老師要被添加，則觸發(fā)該觸發(fā)器使得該教師的相關(guān)信息被添加進(jìn)來create trigger insert_teachers on teachersafter insertasbegininsert into teachers values(39。teacherID39。,39。teachername39。,39。sex39。,39。age39。,39。collegename39。,39。department39。,39。tel39。)end
公司管理相關(guān)推薦
鄂ICP備17016276號-1