资源描述：
《北邮数据库实验报告(2).docx》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、数据库实验报告（二）学号：班级:1.按照给出的表用SQLServerManagementStudio（企业管理器）建立表B-1,表B-2,表B-3book：class:course:1.用Transact-SQL语句建立表B-5,表B-6,表B-7,表B-8,表B-9createtabledepartment(department_idnchar(10)notnullprimarykey,department_namenchar(10),department_headernchar(10),teacher_numnchar(1
2、0))createtablestudent(student_idnchar(10)notnullprimarykey,student_namenchar(10),sexnchar(10),birthnchar(10),entrance_datenchar(10),home_addrnchar(10),emailnchar(10))createtablestudent_course(course_idnchar(10)notnull,student_idnchar(10)notnull,gradenchar(10),credit
3、nchar(10),semesternchar(10),school_yearnchar(10),constraintC2primarykey(course_id,student_id))createtableteacher(teacher_idnchar(10)notnullprimarykey,teacher_namenchar(10),sexnchar(10),birthnchar(10),department_idnchar(10),professionnchar(10),telephonenchar(10),home
4、_addrnchar(10),postalcodenchar(10),emailnchar(10))createtableteacher_course_class(teacher_idnchar(10)notnull,course_idnchar(10)notnull,class_idnchar(10)notnull,semesternchar(10),school_yearnchar(10),course_schedulenchar(10),course_classroomnchar(10),book_idnchar(10)
5、,constraintC3primarykey(teacher_id,course_id,class_id))结果图：department:student:student_course:teacher:teacher_course_class:1.为每个表建立主键。在建表的时候已经建立。结果见上面的截图。1.对Course表建立如下约束：course_name非空，credit取值在1-6之间altertablecourseaddconstraintC1check(creditbetween1and6)2.为student_c
6、ourse表、teacher_course_class表创建外键，建立参照完整性约束，分别用SQLServerManagementStudio（企业管理器）和Transact-SQL语句完成。altertablestudent_courseaddconstraintFK1foreignkey(course_id) referencescourse(course_id),constraintFK2foreignkey(student_id) referencesstudent(student_id)ondeletecascade
7、altertableteacher_course_classaddconstraintFK3foreignkey(book_id) referencesbook(book_id), constraintFK4foreignkey(teacher_id) referencesteacher(teacher_id), constraintFK5foreignkey(course_id) referencescourse(course_id), constraintFK6foreignkey(class_id) references
8、class(class_id) ondeletecascade1.修改Student和teacher表，分别增加一列用于存储学生和教师的E_mail地址。altertablestudentaddemailchar(20)altertableteacheraddemailcha
