资源描述：
《数据库代码实验六.doc》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。
1、实验三代码createtableCourse(Cidchar(6)primarykey,Cnamechar(20)unique,Ccreditint);createtableTeacher(Tidchar(6)primarykey,Tnamechar(20),Tdeptchar(20),TstartDatechar(20));createtableClass(Classidchar(6)primarykey,ClassDeptchar(10));createtableClassroom(Roomidchar(6)primar
2、ykey,Buildingchardefault'TB1',RoomTypechar(20));createtableStudent(Sidchar(6),Snamechar(20)ConstraintSnameUniqueUnique(Sname),SagesmallintConstraintSageConstraintcheck(Sage>=10andSage<=30),Ssexchar(2)Check(Ssexin('F','M'))ConstraintSexDefaultDefault'M',Classidchar(
3、6),primarykey(Sid));createtableDepartment(Deptidchar(6),Dnamechar(20),Dchairmanchar(20),primarykey(Deptid),);createtableEnrollment(Sidchar(6)notnull,Cidchar(6)notnull,gradesmallintcheck(grade>=0andgrade<=100),semesterchar(10),typechar(20),primarykey(Sid,Cid),foreig
4、nkey(Sid)referencesStudent(Sid),foreignkey(Cid)referencesCourse(Cid));createtableClassAssign(Classidchar(6)notnull,Roomidchar(6)notnull,Ctimechar(20),primarykey(Classid,Roomid),foreignkey(Classid)referencesClass(Classid),foreignkey(Roomid)referencesClassroom(Roomid
5、));实验四代码1、AcreateclusteredindexCoucidonCourse(Cid);createclusteredindexTeatidonTeacher(Tid);createclusteredindexClaclassidonClass(Classid);createclusteredindexClaroomidonClassroom(Roomid);createclusteredindexStusidonStudent(Sid);createclusteredindexDepdeptidonDepar
6、tment(Deptid);createclusteredindexEnrsidonEnrollment(Sid,Cid);createclusteredindexClaidonClassAssign(Classid,Roomid);BcreateuniqueindexCoucnameonCourse(Cname);CcreateuniqueindexDepdnameonDepartment(Dname);DcreateindexStunamesageonStudent(Snameasc,Sagedesc);Ecreatev
7、iewMA_StudentASSelectSid,Sname,Sage,Ssex,ClassidfromStudent,DepartmentwhereDname='MA'withcheckoptionFdropindexStudent.Stunamesage;2、AselectSid,Sname,SagefromStudent,DepartmentwhereDname='MA';BselectSidfromStudent,DepartmentwhereDname='CS'andSage<19;Cselectavg(Sage)
8、fromStudentwhereClassid='信息1班';DSelectStudent.Sid,SnameFromStudent,EnrollmentWhereStudent.Sid=Enrollment.SidandEnrollment.grade>=(SelectMax(grade
