yuangongguanlixitong.zip_vb SQL Server

USE ym go CREATE TABLE staffinfo (sno int PRIMARY KEY , sname char(10) NOT NULL, ssex char(2) check (ssex in('男','女')), sbrith datetime, sdepart char(6), sjob char(10), ); CREATE TABLE courseinfo (cno int PRIMARY KEY, cname char(20), cdescribe char(20), ); CREATE TABLE planinfo (pno int PRIMARY KEY, pbegin char(8), pend char(8), pplace char(10), pcontent char(20), pdirector int, pstate char(10), foreign key (pno) references approvalinfo(pno) on delete cascade on update cascade, ); CREATE TABLE approvalinfo (pno int PRIMARY KEY, asource char(10), amoney int, aresult char(16), adirector int ); CREATE TABLE grade (sno int NOT NULL, sname char(10), cno int NOT NULL, cname char(20), grade int, PRIMARY KEY(sno,cno) ); CREATE TABLE userinfo (userid char(10) PRIMARY KEY, userpwd char(10) NOT NULL, username char(20), userlevel int ); alter table grade add constraint id_fk foreign key (sno) references staffinfo (sno) on delete cascade on update cascade alter table grade add constraint id_fk1 foreign key (cno) references courseinfo (cno) on delete cascade on update cascade alter table planinfo add constraint id_fk2 foreign key (pno) references approvalinfo (pno) on delete no action on update no action create trigger t1 on approvalinfo for insert as delete from planinfo where pno in (select pno from approvalinfo where aresult='不合格' ) create trigger t2 on approvalinfo for update as delete from planinfo where pno in (select pno from approvalinfo where aresult='不合格' )