【正文】 受數(shù)據(jù)庫(kù)管理系統(tǒng)發(fā)回的操作結(jié)果顯示在界面上。在實(shí)現(xiàn)數(shù)據(jù)庫(kù)數(shù)據(jù)的完整性和安全性上，前臺(tái)程序提供了功能上的支持。（二）具體物理實(shí)現(xiàn)數(shù)據(jù)庫(kù)物理結(jié)構(gòu)設(shè)計(jì)（建庫(kù)、建表、索引、視圖、觸發(fā)器、存儲(chǔ)過(guò)程、事務(wù)）；初始數(shù)據(jù)錄入。建庫(kù)create database SelectCourseon(name=selectcourse,filename=39。D:\SelectCourse\39。)建表（1）、用戶表（用戶名，用戶密碼）use SelectCoursecreate table Admins(Name varchar(10)not null primary key, Passwords varchar(8)not null) insert into Adminsvalues(39。abc39。,39。12339。)insert Adminsvalues(39。bcd39。,39。12339。)insert Adminsvalues(39。vnd39。,39。12839。)insert Adminsvalues(39。khd39。,39。12939。)insert Adminsvalues(39。qwerty39。,39。12539。)insert into Adminsvalues(39。dfg39。,39。12339。)insert Adminsvalues(39。fds39。,39。12339。)insert Adminsvalues(39。gdg39。,39。12839。)insert Adminsvalues(39。gde39。,39。12939。)insert Adminsvalues(39。qwe39。,39。12539。)select * from Admins（2）、課程類(lèi)別表（課程類(lèi)別號(hào)，課程類(lèi)別名稱）use SelectCoursecreate table CouCateTb(CouCateId varchar(6)not null primary key,CouCate nvarchar(20)not null)insert into CouCateTbvalues(39。10139。,39。計(jì)算機(jī)39。)insert CouCateTbvalues(39。10239。,39。管理類(lèi)39。)insert CouCateTbvalues(39。10339。,39?；ゎ?lèi)39。)insert CouCateTbvalues(39。10439。,39。機(jī)械類(lèi)39。)insert CouCateTbvalues(39。10539。,39。藝術(shù)類(lèi)39。)select * from CouCateTb（3）、系別表（系別號(hào)，系別名稱）use SelectCoursecreate table DeptTb(DeptId varchar(2)not null primary key,DeptName nvarchar(20)not null)insert into DeptTbvalues(39。JS39。,39。計(jì)算機(jī)系39。)insert DeptTbvalues(39。GL39。,39。管理系39。)insert DeptTbvalues(39。HG39。,39?；は?9。)insert DeptTbvalues(39。JC39。,39。機(jī)車(chē)系39。)insert DeptTbvalues(39。YS39。,39。藝術(shù)系39。)select * from DeptTb（4）、學(xué)生表（學(xué)號(hào)，姓名，性別，籍貫，系別號(hào)，專(zhuān)業(yè)）use SelectCoursecreate table StudentTb(StudentId varchar(8)not null primary key,StudentName varchar(10)not null,Sex char(2)not null,StuHome varchar(30) not null,DeptId varchar(2)not null,constraint DeptId_StudentTb foreign key (DeptId)references DeptTb(DeptId),major varchar(20) not null)insert StudentTbvalues(39。0108030139。,39。楊楊39。,39。男39。,39。廣東廣州39。,39。JS39。,39。軟件測(cè)試39。,39。優(yōu)秀39。)insert StudentTbvalues(39。0108030239。,39。李鵬39。,39。男39。,39。廣東深圳39。,39。JS39。,39。軟件測(cè)試39。,39。良好39。)insert StudentTbvalues(39。0108030339。,39。王海39。,39。男39。,39。廣東珠海39。,39。JS39。,39。軟件測(cè)試39。,39。優(yōu)秀39。)insert StudentTbvalues(39。0108030439。,39。朱紅39。,39。女39。,39。天津39。,39。JS39。,39。軟件測(cè)試39。,39。良好39。)insert StudentTbvalues(39。0108030539。,39。李一39。,39。男39。,39。廣東深圳39。,39。JS39。,39。軟件測(cè)試39。,39。優(yōu)秀39。)insert StudentTbvalues(39。0108030639。,39。王二39。,39。男39。,39。廣東珠海39。,39。JS39。,39。軟件測(cè)試39。,39。良好39。)insert StudentTbvalues(39。0108030739。,39。楊三39。,39。男39。,39。廣東廣州39。,39。JS39。,39。軟件測(cè)試39。,39。良好39。)insert StudentTbvalues(39。0108030839。,39。李四39。,39。女39。,39。廣東深圳39。,39。JS39。,39。軟件測(cè)試39。,39。優(yōu)秀39。)insert StudentTbvalues(39。0108030939。,39。王五39。,39。女39。,39。廣東珠海39。,39。JS39。,39。軟件測(cè)試39。,39。良好39。)insert StudentTbvalues(39。0108031039。,39。王六39。,39。女39。,39。廣東珠海39。,39。JS39。,39。軟件測(cè)試39。,39。中等39。)insert StudentTbvalues(39。0108031139。,39。楊二39。,39。男39。,39。廣東廣州39。,39。JS39。,39。軟件測(cè)試39。,39。優(yōu)秀39。)insert StudentTbvalues(39。0108031239。,39。李玲39。,39。女39。,39。廣東深圳39。,39。JS39。,39。軟件測(cè)試39。,39。中等39。)insert StudentTbvalues(39。0108031339。,39。王價(jià)39。,39。男39。,39。廣東揭陽(yáng)39。,39。JS39。,39。軟件測(cè)試39。,39。優(yōu)秀39。)insert StudentTbvalues(39。0108031439。,39。朱三39。,39。女39。,39。廣東清遠(yuǎn)39。,39。JS39。,39。軟件測(cè)試39。,39。中等39。)insert StudentTbvalues(39。0108031539。,39。李明39。,39。男39。,39。廣東深圳39。,39。JS39。,39。軟件測(cè)試39。,39。優(yōu)秀39。)insert into StudentTbvalues(39。0208010139。,39。丁香39。,39。女39。,39。廣東清遠(yuǎn)39。,39。GL39。,39。會(huì)計(jì)學(xué)39。,39。中等39。)insert into StudentTbvalues(39。0208010239。,39。趙縣39。,39。男39。,39。上海浦東39。,39。GL39。,39。會(huì)計(jì)學(xué)39。,39。優(yōu)秀39。)insert into StudentTbvalues(39。0208010339。,39。李靜39。,39。女39。,39。廣東揭陽(yáng)39。,39。GL39。,39。會(huì)計(jì)學(xué)39。,39。中等39。)insert into StudentTbvalues(39。0208010439。,39。王同同39。,39。男39。,39。上海39。,39。GL39。,39。會(huì)計(jì)學(xué)39。,39。優(yōu)秀39。)insert into StudentTbvalues(39。0208010539。,39。李茯苓39。,39。女39。,39。內(nèi)蒙古39。,39。GL39。,39。會(huì)計(jì)學(xué)39。,39。中等39。)insert into StudentTbvalues(39。0208010639。,39。張大39。,39。男39。,39。新疆39。,39。GL39。,39。會(huì)計(jì)學(xué)39。,39。中等39。)insert into StudentTbvalues(39。0208010739。,39。陳明39。,39。女39。,39。廣東清遠(yuǎn)39。,39。GL39。,39。會(huì)計(jì)學(xué)39。,39。良好39。)insert into StudentTbvalues(39。0208010839。,39。林子39。,39。男39。,39。上海浦東39。,39。GL39。,39。會(huì)計(jì)學(xué)39。,39。良好39。)insert into StudentTbvalues(39。0208010939。,39。何小敏39。,39。女39。,39。廣東揭陽(yáng)39。,39。GL39。,39。會(huì)計(jì)學(xué)39。,39。良好39。)insert into StudentTbvalues(39。0208011039。,39。曾家國(guó)39。,39。男39。,39。上海39。,39。GL39。,39。會(huì)計(jì)學(xué)39。,39。中等39。)insert into StudentTbvalues(39。0208011139。,39。李小龍39。,39。男39。,39。內(nèi)蒙古39。,39。GL39。,39。會(huì)計(jì)學(xué)39。,39。優(yōu)秀39。)insert into StudentTbvalues(39。0208011239。,39。張三星39。,39。男39。,39。新疆39。,39。GL39。,39。會(huì)計(jì)學(xué)39。,39。中等39。)insert into StudentTbvalues(39。0208011339。,39。任東東39。,39。男39。,39。上海39。,39。GL39。,39。會(huì)計(jì)學(xué)39。,39。優(yōu)秀39。)insert into StudentTbvalues(39。0208011439。,39。劉寧39。,39。女39。,39。內(nèi)蒙古39。,39。GL39。,39。會(huì)計(jì)學(xué)39。,39。中等39。)insert into StudentTbvalues(39。0208011539。,39。王強(qiáng)強(qiáng)39。,39。男39。,39。新疆39。,39。GL39。,39。會(huì)計(jì)學(xué)39。,39。中等39。)select * from StudentTb（5）、教師表（教師編碼，教師名字，教師職稱，系別號(hào)）use SelectCoursecreate table TeacherTb(TeacherId char(6)not null primary key,TeaName char(10)not null,TeaTitle char(10)not null,DeptId varchar(2)not null,constraint DeptId_TeacherTb for