教務(wù)網(wǎng)絡(luò)管理系統(tǒng)(已改無錯(cuò)字)
2023-05-13 12:58:12 本頁面
【正文】 nstraint teacher_course_class_id_pkprimary key(teacher_id,class_id,course_id)goCHECK約束student_course表alter table student_courseadd constraint grade_ckcheck (grade between 0 and 100)gostudent表alter table studentadd constraint student_id_ckcheck (student_id like (39。[Az][09][09][09][09][09][09][09]39。))默認(rèn)約束student表alter table studentadd constraint student_sex_dfdefault1 for sexteacher表alter table teacheradd constraint teacher_sex_dfdefault1 for sexgoadd constraint teacher_semester_dfdefault1 for ‘1’go外鍵約束student表alter table studentadd constraint class_id_fkforeign key (class_id)references class(class_id) on delete cascadegobook表：無外鍵class表：無外鍵teacher表：無外鍵course表alter table courseadd constraint book_id_fkforeign key (book_id)references book(book_id) on delete cascadegoclass_course表alter table class_courseadd constraint class1_id_fkforeign key (class_id)references class(class_id) on delete cascadegoalter table class_courseadd constraint course1_id_fkforeign key (course_id)references course(course_id) on delete cascadegostudent_course表alter ta add constraint course2_id_fkforeign key (course_id)references course(course_id) on delete cascadegoalter table student_course ble student_courseadd constraint student_id_fkforeign key (student_id)references student(student_id) on delete cascadegoteacher _course_class表alter table teacher_course_classadd constraint course3_id_fkforeign key (course_id)references course(course_id) on delete cascadegoalter table teacher_course_classadd constraint teacher_id_fkforeign key (teacher_id)references teacher(teacher_id) on delete cascadegoalter table teacher_course_class add constraint class3_id_fkforeign key (class_id)references class(class_id) on delete cascadego創(chuàng)建存儲過程/*向student表插入數(shù)據(jù)*/create procedure student@student_id int,@student_name nvarchar(8),@sex bit,@birth smalldatetime,@class_id char(6),@entrance_date smalldatetime,@home_addr nvarchar(40)asdelete from student where student_id=@student_idinser
公司管理相關(guān)推薦
鄂ICP備17016276號-1