【正文】 tCourseTbvalues(39。,39。,39。,39。,39。,39。,39。,88)insert SelectCourseTbvalues(39。,39。,39。,39。,39。,39。,39。,null)insert into SelectCourseTbvalues(39。,39。,39。,39。,39。,39。,39。,null)insert SelectCourseTbvalues(39。,39。,39。,39。,39。,39。,39。,null)insert into SelectCourseTbvalues(39。,39。,39。,39。,39。,39。,39。insert SelectCourseTbvalues(39。是39。是39。林天39。JS100139。計(jì)算機(jī)基礎(chǔ)39。J0139。0108030339。否39。否39。林天39。JS100139。JAVA語言39。J0639。0108030239。是39。是39。林天39。JS100139。C語言39。J0539。0108030239。是39。是39。劉海39。JS100239。計(jì)算機(jī)工程39。J0439。0108030239。是39。是39。林天39。JS100139。網(wǎng)頁設(shè)計(jì)39。J0339。0108030239。是39。是39。劉海39。JS100239。計(jì)算機(jī)應(yīng)用39。J0239。0108030239。否39。是39。林天39。JS100139。計(jì)算機(jī)基礎(chǔ)39。J0139。0108030239。,85),39。,39。,39。,39。,39。,39。,80)insert into SelectCourseTbvalues(39。,39。,39。,39。,39。,39。,39。,95)insert SelectCourseTbvalues(39。,39。,39。,39。,39。,39。,39。,null)insert into SelectCourseTbvalues(39。,39。,39。,39。,39。,39。,39。,null)insert SelectCourseTbvalues(39。,39。,39。,39。,39。,39。,39。,null)insert into SelectCourseTbvalues(39。,39。,39。,39。,39。,39。,39。CouId char(4)not null,constraint CouId_SelectCourseTb foreign key (CouId)references CourseTb(CouId),CouName varchar(10)not null,TeacherId char(6)not null,TeaName char(10)not null,SelectYesOrNO char(2)not null,TestYesOrNO char(2) not null,Grade int null,constraint S primary key (StudentId,CouId,TeacherId))insert into SelectCourseTbvalues(39。select * from CourseTbYS101039。239。10539。審美藝術(shù)39。Y1039。YS100939。139。10539。現(xiàn)代藝術(shù)39。Y0939。JC100839。339。10439。自動(dòng)化39。C0839。JC100739。139。10439。車輛工程39。C0739。HG100639。239。10339?；?shí)驗(yàn)39。H0639。HG100539。339。10339。化工與材料39。H0539。),39。,39。,39。,39。)insert CourseTbvalues(39。,39。,39。,39。,39。)insert CourseTbvalues(39。,39。,39。,39。,39。)insert CourseTbvalues(39。,39。,39。,39。,39。)insert CourseTbvalues(39。,39。,39。,39。,39。)insert CourseTbvalues(39。,39。,39。,39。,39。insert CourseTbvalues(39。JS100239。339。10139。JAVA語言39。J0639。),39。,39。,39。,39。insert into CourseTbvalues(39。JS100239。339。10139。計(jì)算機(jī)工程39。J0439。),39。,39。,39。,39。insert into CourseTbvalues(39。JS100239。339。10139。計(jì)算機(jī)應(yīng)用39。J0239。),39。,39。,39。,39。insert into CourseTbvalues(39。)select * from TeacherTb,39。,39。,39。)insert TeacherTbvalues(39。,39。,39。,39。insert TeacherTbvalues(39。JC39。講師39。高義義39。JC100839。JC39。副教授39。王山39。JC100739。),39。,39。,39。)insert TeacherTbvalues(39。,39。,39。,39。insert TeacherTbvalues(39。GL39。副教授39。何敏39。GL100439。GL39。教授39。李立39。GL100339。),39。,39。,39。)insert TeacherTbvalues(39。,39。,39。,39。insert TeacherTbvalues(39。select * from StudentTb中等39。會(huì)計(jì)學(xué)39。GL39。新疆39。男39。王強(qiáng)強(qiáng)39。0208011539。中等39。會(huì)計(jì)學(xué)39。GL39。內(nèi)蒙古39。女39。劉寧39。0208011439。優(yōu)秀39。會(huì)計(jì)學(xué)39。GL39。上海39。男39。任東東39。0208011339。中等39。會(huì)計(jì)學(xué)39。GL39。新疆39。男39。張三星39。0208011239。優(yōu)秀39。會(huì)計(jì)學(xué)39。GL39。內(nèi)蒙古39。男39。李小龍39。0208011139。中等39。會(huì)計(jì)學(xué)39。GL39。上海39。男39。曾家國39。0208011039。良好39。會(huì)計(jì)學(xué)39。GL39。廣東揭陽39。女39。何小敏39。0208010939。良好39。會(huì)計(jì)學(xué)39。GL39。上海浦東39。男39。林子39。0208010839。良好39。會(huì)計(jì)學(xué)39。GL39。廣東清遠(yuǎn)39。女39。陳明39。0208010739。中等39。會(huì)計(jì)學(xué)39。GL39。新疆39。男39。張大39。0208010639。中等39。會(huì)計(jì)學(xué)39。GL39。內(nèi)蒙古39。女39。李茯苓39。0208010539。優(yōu)秀39。會(huì)計(jì)學(xué)39。GL39。上海39。男39。王同同39。0208010439。中等39。會(huì)計(jì)學(xué)39。GL39。廣東揭陽39。女39。李靜39。0208010339。優(yōu)秀39。會(huì)計(jì)學(xué)39。GL39。上海浦東39。男39。趙縣39。0208010239。中等39。會(huì)計(jì)學(xué)39。GL39。廣東清遠(yuǎn)39。女39。丁香39。0208010139。),39。,39。,39。,39。,39。,39。)insert StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert StudentTbvalues(39。,39。,39。,39。,39。,39。,39。insert StudentTbvalues(39。),39。)insert DeptTbvalues(39。,39。)insert DeptTbvalues(39。,39。)insert DeptTbvalues(39。,39。)insert DeptTbvalues(39。,39。insert into DeptTbvalues(39。（3）、系別表（系別號(hào)，系別名稱）use SelectCoursecreate table DeptTb(DeptId varchar(2)not null primary key,DeptName nvarchar(20)not null)),39。)insert CouCateTbvalues(39。,39。)insert CouCateTbvalues(39。,39。)insert CouCateTbvalues(39。,39。)insert CouCateTbvalues(39。,39。insert into CouCateTbvalues(39。)select * from Admins（2）、課程類別表（課程類別號(hào)，課程類別名稱）use SelectCoursecreate table CouCateTb(CouCateId varchar(6)not null primary key,CouCate nvarchar(20)not null),39。)insert Adminsvalues(39。,39。)insert Adminsvalues(39。,39。)insert Adminsvalues(39。,39。)insert Adminsvalues(39。,39。insert into Adminsvalues(39。12539。qwerty39。12939。khd39。12839。vnd39。12339。bcd39。12339。abc39。Name varchar(10)not null primary key,)建庫create database SelectCourseon(name=selectcourse,filename=39。在實(shí)現(xiàn)數(shù)據(jù)庫數(shù)據(jù)的完整性和安全性上，前臺(tái)程序提供了功能上的支持。前臺(tái)程序?qū)嶋H上是一個(gè)人與數(shù)據(jù)庫的接口，或稱界面。后臺(tái)數(shù)據(jù)庫存儲(chǔ)數(shù)據(jù)表，接受前臺(tái)程序的查詢和更新要求，并向前臺(tái)程序提供數(shù)據(jù)庫服務(wù)?？紤]到基于SQL語言的數(shù)據(jù)庫的先進(jìn)性