【正文】 D TYPE=39。)DROP TRIGGER Sno_student_triGOcreate trigger Sno_student_tri on Student for update as if update(Sno) begin declare Sno_new char(10),Sno_old char(10) select Sno_new=Sno from inserted select Sno_old=Sno from deleted update SC set Sno=Sno_new where Sno=Sno_old update HuoJiang set Sno=Sno_new where Sno=Sno_old update WeiJi set Sno=Sno_new where Sno=Sno_oldendgo建立一個觸發(fā)器，修改SC中的一個學號，如果Stdent中存在該學號，則不許修改，如不存在，則可以修改。f:\studentrecorddb\StudentRecordDB 39。 開發(fā)背景隨著我國市場經(jīng)濟的快速發(fā)展和信息化水平的不斷提高和網(wǎng)絡(luò)運用的不斷普及，如何利用先進的管理手段，提高高校管理的水平，是當今社會所面臨的一個課題。)GO班級表：CREATE TABLE Class( ClassID CHAR(8) NOT NULL, ClassName CHAR(20) NOT NULL, DeptID CHAR(8) NULL,)院系表CREATE TABLE College( CollegeID CHAR(8) NOT NULL, CollegeName CHAR(20) NOT NULL, CollegeSummary CHAR(10) NULL,)課程表CREATE TABLE Course( Cno CHAR(10) NOT NULL, Cname CHAR(10) NOT NULL, keshi int NOT NULL, xuefen int NOT NULL, ksxs char(8) NOT NULL)系表：CREATE TABLE Dept( DeptID CHAR(8) NOT NULL, DeptName CHAR(30) NOT NULL, CollegeID CHAR(8) NULL)獲獎表：CREATE TABLE HuoJiang( Sno CHAR(10) NOT NULL, RewardID CHAR(8) NOT NULL, Time datetime NULL)處罰表：CREATE TABLE Punish( PunishID char(8) NOT NULL, PunishName char(10) NULL)獎勵表：CREATE TABLE Reward( RewardID char(8) NOT NULL, RewardName char(10) NOT NULL, RewardLevel char(10) NOT NULL)宿舍表：CREATE TABLE Room( RoomID char(8) NOT NULL, RoomAdd char(20) NOT NULL, RoomNum int NOT NULL)選課表：CREATE TABLE SC( Sno char(10) NOT NULL, Cno char(10) NOT NULL, Score int NULL)1學生表：CREATE TABLE Student( Sno char(10) NOT NULL, S_name char(8) NOT NULL, S_xmpy char(20) NOT NULL, S_cym char(8) NULL, S_sex char(2) NOT NULL, S_age int NOT NULL, S_mz char(10) NOT NULL, S_jg char(100) NOT NULL, S_csrq datetime NOT NULL, RommID int NULL, ClassID int NULL, S_sfzh char(15) NOT NULL, S_image image NULL, S_zzmm char(4) NOT NULL, S_csd char(100) NULL, S_syd char(100) NOT NULL, S_rxnf datetime NOT NULL, S_byxx char(20) NOT NULL, S_pycc char(10) NOT NULL, S_jtzz char(100) NOT NULL, S_jtlxdh char(15) NULL, S_sj char(11) NULL)1用戶表：CREATE TABLE Users( Uid int NOT NULL, Uname char(20) NOT NULL, PassWord char(20) NOT NULL)1違紀記錄表：CREATE TABLE WeiJi( Sno char(10) NOT NULL, PunishID char(8) NOT NULL, Time datetime NOT NULL, chulijieguo text NULL)GO二、視圖查詢成績USE StudentRecordDBGOCREATE VIEW SCORE_VIEW AS SELECT , S_name,Cname, Score FROM Student,Course,SC WHERE = AND =GO查詢基本信息USE StudentRecordDBGOCREATE VIEW jbxx_VIEW AS SELECT ,S_name,S_sex,S_age,S_jg,S_zzmm,S_rxnf, S_jtzz,S_sj, FROM Student,Class,Dept,Room WHERE = AND = AND =GO查詢獲獎情況USE StudentRecordDBGOCREATE VIEW HJ_VIEW AS SELECT , S_name, RewardName FROM Student,HuoJiang,Reward WHERE = AND =GO查詢違紀情況USE StudentRecordDBGOCREATE VIEW CF_VIEW AS SE