【正文】 ，也需要后臺(tái)數(shù)據(jù)庫的支持。它負(fù)責(zé)接受用戶的查詢和更新請(qǐng)求，并將這些請(qǐng)求轉(zhuǎn)化為數(shù)據(jù)庫管理系統(tǒng)（DBMS）能識(shí)別的數(shù)據(jù)庫操作語言，再接受數(shù)據(jù)庫管理系統(tǒng)發(fā)回的操作結(jié)果顯示在界面上。（二）具體物理實(shí)現(xiàn)數(shù)據(jù)庫物理結(jié)構(gòu)設(shè)計(jì)（建庫、建表、索引、視圖、觸發(fā)器、存儲(chǔ)過程、事務(wù)）；初始數(shù)據(jù)錄入。D:\SelectCourse\39。建表（1）、用戶表（用戶名，用戶密碼）use SelectCoursecreate table Admins( Passwords varchar(8)not null) insert into Adminsvalues(39。,39。)insert Adminsvalues(39。,39。)insert Adminsvalues(39。,39。)insert Adminsvalues(39。,39。)insert Adminsvalues(39。,39。)dfg39。12339。fds39。12339。gdg39。12839。gde39。12939。qwe39。12539。10139。計(jì)算機(jī)39。10239。管理類39。10339?；ゎ?9。10439。機(jī)械類39。10539。藝術(shù)類39。select * from CouCateTbJS39。計(jì)算機(jī)系39。GL39。管理系39。HG39?；は?9。JC39。機(jī)車系39。YS39。藝術(shù)系39。select * from DeptTb（4）、學(xué)生表（學(xué)號(hào)，姓名，性別，籍貫，系別號(hào)，專業(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)0108030139。楊楊39。男39。廣東廣州39。JS39。軟件測試39。優(yōu)秀39。0108030239。李鵬39。男39。廣東深圳39。JS39。軟件測試39。良好39。0108030339。王海39。男39。廣東珠海39。JS39。軟件測試39。優(yōu)秀39。0108030439。朱紅39。女39。天津39。JS39。軟件測試39。良好39。0108030539。李一39。男39。廣東深圳39。JS39。軟件測試39。優(yōu)秀39。0108030639。王二39。男39。廣東珠海39。JS39。軟件測試39。良好39。0108030739。楊三39。男39。廣東廣州39。JS39。軟件測試39。良好39。0108030839。李四39。女39。廣東深圳39。JS39。軟件測試39。優(yōu)秀39。0108030939。王五39。女39。廣東珠海39。JS39。軟件測試39。良好39。0108031039。王六39。女39。廣東珠海39。JS39。軟件測試39。中等39。0108031139。楊二39。男39。廣東廣州39。JS39。軟件測試39。優(yōu)秀39。0108031239。李玲39。女39。廣東深圳39。JS39。軟件測試39。中等39。0108031339。王價(jià)39。男39。廣東揭陽39。JS39。軟件測試39。優(yōu)秀39。0108031439。朱三39。女39。廣東清遠(yuǎn)39。JS39。軟件測試39。中等39。0108031539。李明39。男39。廣東深圳39。JS39。軟件測試39。優(yōu)秀39。insert into StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert into StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert into StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert into StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert into StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert into StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert into StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert into StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert into StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert into StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert into StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert into StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert into StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert into StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)insert into StudentTbvalues(39。,39。,39。,39。,39。,39。,39。)（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 foreign key (DeptId)references DeptTb(DeptId))JS100139。林天39。教授39。JS39。JS100239。劉海39。副教授39。JS39。insert into TeacherTbvalues(39。,39。,39。,39。)insert into TeacherTbvalues(39。,39。,39。,39。)HG100539。張呂一39。講師39。HG39。HG100639。呂虹39。副教授39。HG39。insert TeacherTbvalues(39。,39。,39。,39。)insert TeacherTbvalues(39。,39。,39。,39。)YS100939。肖妮兒39。講師39。YS39。YS101039。李婷39。教授39。YS39。（6）、課程表（課程號(hào)，課程名稱，課程類別號(hào)，課程總學(xué)分，任課教師編碼）use SelectCoursecreate table CourseTb(CouId char(4)not null primary key,CouName varchar(10)not null,CouCateId varchar(6)not null,constraint CouCateId_CourseTb foreign key (CouCateId)references CouCateTb(CouCateId),Credits int not null,TeacherId char(6)not null,constraint TeacherId_CourseTb foreign key (TeacherId)references TeacherTb(TeacherId))J0139。計(jì)算機(jī)基礎(chǔ)39。10139。439。JS100139。insert into CourseTbvalues(39。,39。,39。,39。,39。)J0339。網(wǎng)頁設(shè)計(jì)39。10139。439。JS100139。insert into CourseTbvalues(39。,39。,39。,39。,39。)J0539。C語言39。10139。439。JS100139。insert into CourseTbvalues(39。,39。,39。,39。,39。)G0339。市場營銷39。10239。339。GL100339。G0439。會(huì)計(jì)學(xué)39。10239。339。GL100439。G0539。網(wǎng)絡(luò)營銷39。10239。439。GL100339。G0639。財(cái)務(wù)管理學(xué)39。10239。239。GL100439。G0139。會(huì)計(jì)電算化39。10239。339。GL100339。G0239。會(huì)計(jì)基礎(chǔ)39。10239。339。GL100439。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。,39。,39。,39。,39。)（7）、選課表（學(xué)號(hào)，課程號(hào)，課程名稱，教師編號(hào)，教師名字，課程是否已選，是否已考試）use SelectCoursecreate table SelectCourseTb(StudentId varchar(8)not null,0108030139。J0139。計(jì)算機(jī)基礎(chǔ)39。JS100139。林天39。是39。否39。0108030139。J0239。計(jì)算機(jī)應(yīng)用39。JS100239。劉海39。是39。否39。0108030139。J0339。網(wǎng)頁設(shè)計(jì)39。JS100139。林天39。是39。是39。0108030139。J0439。計(jì)算機(jī)工程39。JS100239。劉海39。是39。是39。0108030139。J0539。C語言39。JS100139。林天39。是39。是39。0108030139。J0639。JAVA語言39。JS100139。林天39。是39。是39。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。,90)insert into SelectCourseTbvalues(39。,39。,39。,39。,39。,39。,39。,98)insert SelectCourseTbvalues(39。,39。,39。,39。,39。,39。,39。,92)insert into SelectCourseTbvalues(39。,39。,39。,39。,39。,39。,39。,null)insert SelectCourseTb(StudentId,CouId,CouName,Teach