【文章內(nèi)容簡(jiǎn)介】 ,39。二39。,39。三39。,39。四39。,39。五39。))。（10）在表ZD_ticket上建立CHECK（檢查約束）chk_zd_10ALTER TABLE ZD_ticketADDCONSTRAINT chk_zd_10CHECK(TI_Nature IN (39?；疖?chē)票39。,39。汽車(chē)票39。,39。飛機(jī)票39。))。 建立觸發(fā)器（1）建立觸發(fā)器,不允許向ZD_zd表中插入數(shù)據(jù)create trigger trigger_1on ZD_zdinstead of insertas begin select 39。不允許向旅行社表中插入數(shù)據(jù)39。 as 39。失敗原因39。endgo（2）建立觸發(fā)器,不允許開(kāi)始時(shí)間大于結(jié)束時(shí)間 drop trigger trigger_2create trigger trigger_2on ZD_groupafter insertas begin select G_Stime,G_Etimefrom insertedif 39。G_Stime39。=39。G_Etime39。beginselect 39。時(shí)間輸入錯(cuò)誤,請(qǐng)檢查39。 as 39。失敗原因39。rollback transaction endendgo（3）建立觸發(fā)器,不允許員工年齡小于或大于 drop trigger trigger_3create trigger trigger_3on ZD_staffafter insertas begin select S_Agefrom insertedif 39。S_Age39。 not between 39。1839。 and 39。5039。beginselect 39。年齡輸入錯(cuò)誤,請(qǐng)檢查39。 as 39。失敗原因39。rollback transaction endendgo（4）建立觸發(fā)器,不允許客戶小于或大于 drop trigger trigger_4create trigger trigger_4on ZD_clientafter insertas begin select C_Agefrom insertedif 39。C_Age39。 not between 39。1839。 and 39。5039。beginselect 39。年齡輸入錯(cuò)誤,請(qǐng)檢查39。 as 39。失敗原因39。rollback transaction endendgo（5）在ZD_decide上建立觸發(fā)器,確保數(shù)據(jù)的正確關(guān)聯(lián) drop trigger trigger_5create trigger trigger_5on ZD_decideafter insertas begindeclare @bl1 char(8)= (select G_Id from inserted)declare @bl2 char(8)= (select T_Id from inserted)declare @bl3 date=(select T_Time from ZD_travel where T_Id=@bl2)declare @bl4 date=(select G_Stime from ZD_group where G_Id=@bl1)declare @bl5 date=(select G_Etime from ZD_group where G_Id=@bl1)declare @bl6 varchar(10)=(select G_City from ZD_group where G_Id=@bl1)declare @bl7 varchar(10)=(select T_City from ZD_travel where T_Id=@bl2)if @bl3@bl4 or @bl3@bl5 or @bl6@bl7beginselect 39。信息不匹配39。 as 39。失敗原因39。rollback transaction endendgo（6）在ZD_acpany上建立觸發(fā)器,確保數(shù)據(jù)的正確關(guān)聯(lián) drop trigger trigger_6create trigger trigger_6on ZD_acpanyafter insertas begindeclare @bl1 char(8)= (select G_Id from inserted)declare @bl2 date= (select A_Acco from inserted)declare @bl4 date=(select G_Stime from ZD_group where G_Id=@bl1)declare @bl5 date=(select G_Etime from ZD_group where G_Id=@bl1)if @bl2@bl4 or @bl2@bl5beginselect 39。信息不匹配39。 as 39。失敗原因39。rollback transaction endendgo（7）在ZD_arrange上建立觸發(fā)器,確保數(shù)據(jù)的正確關(guān)聯(lián) drop trigger trigger_7create trigger trigger_7on ZD_arrangeafter insertas begindeclare @bl1 char(8)= (select G_Id from inserted)declare @bl2 date= (select AR_Time from inserted)declare @bl4 date=(select G_Stime from ZD_group where G_Id=@bl1)declare @bl5 date=(select G_Etime from ZD_group where G_Id=@bl1)if @bl2@bl4 or @bl2@bl5beginselect 39。信息不匹配39。 as 39。失敗原因39。rollback transaction endendgo（8）在ZD_apply上建立觸發(fā)器,確保數(shù)據(jù)的正確關(guān)聯(lián) drop trigger trigger_8create trigger trigger_8on ZD_applyafter insertas begindeclare @bl1 char(8)= (select G_Id from inserted)declare @bl2 date= (select AP_Time from inserted)declare @bl4 date=(select G_Stime from ZD_group where G_Id=@bl1)if @bl2=@bl4beginselect 39。信息不匹配39。 as 39。失敗原因39。rollback transaction endendgo代碼：INSERT INTO ZD_zdVALUES(39。Z10039。,39。正大旅行社39。,39。上海正大旅行社是一家綜合性的國(guó)內(nèi)旅游企業(yè)。39。,39。1995010139。,39。上海39。,39。1566149304139。)。INSERT INTO ZD_groupVALUES(39。000139。,39。成都單人兩天游39。,39。2013010139。,39。2013010239。,10,39。Z10039。),(39。000239。,39。包頭單人兩天游39。,39。2013010139。,39。2013010239。,10,39。Z10039。),(39。000339。,39。成都單人兩天游39。,39。2013010239。,39。2013010339。,10,39。Z10039。),(39。000439。,39。包頭單人兩天游39。,39。2013010239。,39。2013010339。,10,39。Z10039。),(39。000539。,39。成都單人兩天游39。,39。2013020139。,39。2013020239。,10,39。Z10039。),(39。000639。,39。包頭單人兩天游39。,39。2013020139。,39。2013020239。,10,39。Z10039。)。INSERT INTO ZD_travelVALUES(39。000139。,39。參觀成都景點(diǎn)39。,39。成都景點(diǎn)......39。,39。2013010139。,39。成都39。),(39。000239。,39。參觀成都景點(diǎn)39。,39。成都景點(diǎn)......39。,39。2013010239。,39。成都39。),(39。000339。,39。參觀成都景點(diǎn)39。,39。成都景點(diǎn)......39。,39。2013010339。,39。成都39。),(39。000439。,39。參觀包頭景點(diǎn)39。,39。包頭景點(diǎn)......39。,39。2013010139。,39。包頭39。),(39。000539。,39。參觀包頭景點(diǎn)39。,39。包頭景點(diǎn)......39。,39。2013010239。,39。包頭39。),(39。000639。,39。參觀包頭景點(diǎn)39。,39。包頭景點(diǎn)......39。,39。2013010339。,39。包頭39。),(39。000739。,39。參觀成都景點(diǎn)39。,39。成都景點(diǎn)......39。,39。2013020139。,39。成都39。),(39。000839。,39。參觀成都景點(diǎn)39。,39。成都景點(diǎn)......39。,39。2013020239。,39。成都39。),(39。000939。,39。參觀包頭景點(diǎn)39。,39。包頭景點(diǎn)......39。,39。2013020139。,39。包頭39。),(39。001039。,39。參觀包頭景點(diǎn)39。,39。包頭景點(diǎn)......39。,39。2013020239。,39。包頭39。)。INSERT INTO ZD_staffVALUES(39。D00139。,39。張毅39。,39。導(dǎo)游39。,39。男39。,21,39。51091234920909876839。,39。1824725678039。),(39。D00239。,39。李毅39。,39。導(dǎo)游39。,39。男39。,28,39。51090259901909876839。,39。1824725678139。),(39。D00339。,39。家明39。,39。導(dǎo)游39。,39。女39。,21,39。51092340900909876839。,39。1824725678239。),(39。D00439。,39。阿牛39。,39。導(dǎo)游39。,39。男39。,23,39。51090251003090987639。,39。1824725678339。),(39。Q00139。,39。蔡依林39。,39。其他39。,39。女39。,21,39。51090409820909878839。,39。182