【文章內(nèi)容簡(jiǎn)介】 type = 39。U39。) drop table 教材發(fā)放goalter table Classmangement add constraint FK_CLASSMAN_RELATIONS_DEPARTME foreign key (Depar_Id) references Departmentform (Depar_Id)goalter table GradeManagement add constraint FK_GRADEMAN_RELATIONS_STUDENTM foreign key (St_Id) references studentmanage (St_Id)goalter table GradeManagement add constraint FK_GRADEMAN_RELATIONS_COURSEIN foreign key (Course_Id) references Courseinformationform (Course_Id)goalter table TeachManage add constraint FK_TEACHMAN_RELATIONS_COURSEIN foreign key (Course_Id) references Courseinformationform (Course_Id)goalter table TeachManage add constraint FK_TEACHMAN_RELATIONS_TEACHERM foreign key (T_Id) references TeacherManage (T_Id)goalter table TeacherManage add constraint FK_TEACHERM_RELATIONS_COURSEIN foreign key (Course_Id) references Courseinformationform (Course_Id)goalter table studentmanage add constraint FK_STUDENTM_RELATIONS_DEPARTME foreign key (Depar_Id) references Departmentform (Depar_Id)goalter table studentmanage add constraint FK_STUDENTM_RELATIONS_CLASSMAN foreign key (class_id) references Classmangement (class_id)goalter table 教材使用 add constraint FK_教材使用_教材使用_COURSEIN foreign key (Course_Id) references Courseinformationform (Course_Id)goalter table 教材使用 add constraint FK_教材使用_教材使用2_SBMANAGE foreign key (SUBID) references SBMANAGE (SUBID)goalter table 教材發(fā)放 add constraint FK_教材發(fā)放_(tái)教材發(fā)放_(tái)STUDENTM foreign key (St_Id) references studentmanage (St_Id)goalter table 教材發(fā)放 add constraint FK_教材發(fā)放_(tái)教材發(fā)放2_SBMANAGE foreign key (SUBID) references SBMANAGE (SUBID)go（一）學(xué)生管理（11）/*==============================================================*//* Table: studentmanage 建立學(xué)生信息表 *//*==============================================================*/create table studentmanage ( St_Name varchar(10) not null, 學(xué)生姓名 St_Id numeric(20) not null, 學(xué)生編號(hào) Depar_Id numeric(10) null, 系部編號(hào) class_id numeric(10) null, 班級(jí)編號(hào) St_Sex varchar(10) not null, 學(xué)生性別 St_Address varchar(50) not null, 學(xué)生住址 St_Tel numeric(20) not null, 學(xué)生電話 St_Bir datetime not null, 學(xué)生生日 constraint PK_STUDENTMANAGE primary key nonclustered (St_Id) 建立主鍵：學(xué)生編號(hào))Go數(shù)據(jù)插入學(xué)生管理插入的相關(guān)信息：insert into values(39。王一39。,100,1,1,39。男39。,39。芙蓉路一號(hào)39。,135641,19890622)insert into values(39。王二39。,101,1,1,39。男39。,39。芙蓉路二號(hào)39。,165941,19890512)insert into values(39。王三39。,102,4,2,39。男39。,39。芙蓉路三號(hào)39。,169941,19881212)insert into values(39。王四39。,103,4,2,39。男39。,39。芙蓉路三號(hào)39。,149941,19881212)insert into values(39。王五39。,104,3,5,39。男39。,39。芙蓉路四號(hào)39。,129941,19900112)insert into values(39。王六39。,105,4,6,39。男39。,39。芙蓉路五號(hào)39。,119941,19900212)insert into values(39。王七39。,106,5,7,39。男39。,39。芙蓉路六號(hào)39。,165541,19900312)insert into values(39。王八39。,107,6,8,39。男39。,39。芙蓉路七號(hào)39。,163341,19900412)insert into values(39。王九39。,108,7,9,39。男39。,39。芙蓉路八號(hào)39。,160041,19900512)insert into values(39。王十39。,109,8,10,39。男39。,39。芙蓉路九號(hào)39。,167941,19900612)insert into values(39。王十一39。,110,9,11,39。男39。,39。芙蓉路十號(hào)39。,163941,19900712)查詢結(jié)果select * from （二）教師管理（11）/*==============================================================*//* Table: TeacherManage 建立教師管理表 *//*==============================================================*/create table TeacherManage ( T_Id numeric(20) not null, 教師編號(hào) Course_Id numeric(10) null, 課程編號(hào) T_Name varchar(10) not null, 教師姓名 T_Sex varchar(5) not null, 教師性別 T_Adress varchar(50) not null, 教師住址 T_level varchar(10) not null, 教師級(jí)別 constraint PK_TEACHERMANAGE primary key nonclustered (T_Id) 建立主鍵：教師編號(hào))Go 數(shù)據(jù)插入教師管理插入的相關(guān)信息：insert into values(1,1,39。張經(jīng)濟(jì)39。,39。男39。,39。萬(wàn)家麗號(hào)39。,39。講師39。)insert into values(2,2,39。張英語(yǔ)39。,39。男39。,39。萬(wàn)家麗號(hào)39。,39。高級(jí)講師39。)insert into values(3,3,39。張德語(yǔ)39。,39。男39。,39。萬(wàn)家麗號(hào)39。,39。高級(jí)講師39。)insert into values(4,4,39。張日語(yǔ)39。,39。男39。,39。萬(wàn)家麗號(hào)39。,39。高級(jí)講師39。)insert into values(5,5,39。張韓語(yǔ)39。,39。男39。,39。萬(wàn)家麗號(hào)39。,39。教授39。) 查詢結(jié)果select * from (三) 教材管理（11）/*==============================================================*//* Table: SBMANAGE 建立教材管理表 *//*==============================================================*/create table SBMANAGE ( SUBID numeric(10) not null,