【正文】 e datetime not null,授課時間primary key(Tno,Cno,Courceno),foreign key(Tno) references Teacher(Tno) on delete cascade,foreign key(Cno) references Class(Cno),foreign key(Courceno) references Cource(Courceno),)insert into Teacher values(39。,39。,39。 , 39。, 39。,39。)insert into Teacher values(39。,39。 ,39。 ,39。, 39。,39。) 《數(shù)據(jù)庫原理》課程設(shè)計報告 20 20insert into Teacher values(39。,39。 ,39。 , 39。, 39。,39。)insert into Teacher values(39。,39。 ,39。 ,39。, 39。,39。)insert into Teacher values(39。,39。 ,39。 ,39。, 39。,39。)insert into Teacher values(39。,39。 ,39。 , 39。, 39。,39。)insert into Teacher values(39。,39。 ,39。 ,39。, 39。,39。)insert into Teacher values(39。,39。,39。 ,39。, 39。,39。)insert into Teacher values(39。,39。 ,39。 ,39。, 39。,39。)insert into Teacher values(39。,39。 ,39。 ,39。, 39。,39。)insert into Teacher values(39。,39。 ,39。 ,39。, 39。,39。)insert into Teacher values(39。,39。 ,39。 ,39。, 39。,39。)insert into Teacher values(39。,39。 ,39。 ,39。, 39。,39。)insert into Teacher values(39。,39。 ,39。 ,39。, 39。,39。)insert into Teacher values(39。,39。 ,39。 ,39。, 39。,39。)insert into Teacher values(39。,39。,39。 ,39。, 39。,39。)insert into Department values (39。,39。,39。)insert into Department values (39。,39。,39。)insert into Department values (39。,39。,39。)insert into Department values (39。,39。,39。)insert into Department values (39。,39。,39。)insert into Department values (39。,39。,39。)insert into Class values (39。,39。, 39。,39。)insert into Class values (39。,39。, 39。,39。)insert into Class values (39。,39。,39。,39。)insert into Class values (39。,39。,39。,39。)insert into Class values (39。,39。,39。,39。)insert into Class values (39。,39。, 39。,39。)insert into Student values(39。,39。,39。,39。, 39。,39。,39。)insert into Student values(39。,39。,39。,39。, 39。,39。,39。)insert into Student values(39。,39。,39。,39。, 39。,39。,39。)insert into Student values(39。,39。,39。,39。, 39。,39。,39。)insert into Student values(39。,39。,39。,39。, 39。,39。, 39。)insert into Cource values(39。,39。, 4,39。)insert into Cource values(39。,39。 ,3,39。)insert into Cource values(39。,39。, 4,39。)insert into Cource values(39。,39。 ,4,39。)insert into Cource values(39。,39。 ,4,39。) 《數(shù)據(jù)庫原理》課程設(shè)計報告 21 21insert into Elective values(39。,39。,39。)insert into Elective values(39。,39。,39。)insert into Elective values(39。,39。,39。)insert into Elective values(39。,39。,39。)insert into Elective values(39。,39。,39。)insert into Classroom values(39。,39。,39。)insert into Classroom values(39。,39。,39。)insert into Classroom values(39。,39。,39。)insert into Classroom values(39。,39。,39。)insert into Classroom values(39。,39。,39。)insert into Classroom values(39。,39。,39。)insert into Occupy values(39。,39。,39。,26)insert into Occupy values(39。,39。,39。,31)insert into Occupy values(39。,39。,39。,38)insert into Occupy values(39。,39。,39。,29)insert into Occupy values(39。,39。,39。,35)insert into Teaching values(39。,39。,39。,39。)insert into Teaching values(39。,39。,39。,39。)insert into Teaching values(39。,39。,39。,39。)insert into Teaching values(39。,39。,39。,39。)insert into Teaching values(39。,39。,39。,39。) 建立視圖：create view StudentViewasselect * from Student：create view MajorViewasselect Smajor,Xname from Class, Student, Departmentwhere = and = with check option：create view GradeViewas 《數(shù)據(jù)庫原理》課程設(shè)計報告 22 22select Sname, ,Grade from Student, Cource, Electivewhere = and = with check option：create view ElectiveViewasselect Sname,Courcename,Courcedirector from Student, Cource,Electivewhere = and = with check option：create view CourceViewasselect Courcename,Courcedirector from Cource：create view AverageView(Sno,AVG_Grade)ASSELECT Sno,AVG (Grade) FROM Electivegroup by Sno 建立存儲過程gocreate procedure Update_Tsaltno char(10)asbeginupdate Teacherset Tsal = 39。where tno=Tnoenddeclaretno1 char(10)set tno1=39。exec Update_Tsal tno1Create procedure Department_insert 《數(shù)據(jù)庫原理》課程設(shè)計報告 23 23Xno char(10), Xname char(10), Xdiredtor char(10) As Insert into Department values(Xno,Xname,Xdiredtor)。0739。市政學(xué)院39。08542639。拒絕修改39。吳迪39。02212439。有新同學(xué)加入39。011300239。周新39。女39。平頂山市新華39。軟件工程39。011339。刪除選課成功39。051300139。0500139。添加新系39。084413139?？脊畔?39。周新新39。02347639。021339。添加課程39。0000139。大學(xué)英語39。03322639。添加新的教室39。083413139。C0339。0400439。011339。11339。2022042639。無法插入該信息39。011111139。02239。0239。20224239。 在教學(xué)信息管理系統(tǒng)的數(shù)據(jù)庫中，由于學(xué)生信息，教師信息等比較重要可以數(shù)據(jù)庫建好之后選擇對數(shù)據(jù)庫進行備份，以免數(shù)據(jù)庫遭到災(zāi)難導(dǎo)致數(shù)據(jù)丟失或損壞，找不到原始數(shù)據(jù)。第 4 章 結(jié)束語在這一星期的學(xué)習(xí)過程中，遇到了很多麻煩，一開始思路打不開總是顛三倒四。感覺怎么畫都達不到一個很好地流向，直到最后也是匆匆的畫了一下大致方向。在解決問題的時候大部分進行的百度，然后就是詢問同學(xué)。參考文獻 [1] 王珊, 薩師煊 數(shù)據(jù)庫系統(tǒng)概論. 高等教育出版社, 2022.[2] 何宗耀，吳孝麗 ，2022