资源描述：
《【9A文】数据库原理与技术简明教程(第二版)课后习题参考答案》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、【MeiWei_81重点借鉴文档】第1章单选题：BBBBC/DCABA简述题：1．略2．星期节数课程星期一1语文星期二1数学星期一2数学星期一3英语。。。。。。。。。。。。。。。。。。姓名养老保险失业保险医疗保险住房公积金张三3005075400李四2705080380王五28050905003．略4．略5．略6．略7．略8．略9．略第2章实践环节设计：1．CREATETABLEStudent(Snochar(7)PRIMARRKER,Snamechar(10)NOTNULL,SseRchar(2)CHECK(SseR='男'ORSseR='女'),Sag
2、etinRintCHECK(Sage>=15ANDSage<=45),Sdeptchar(20)DEFAULT'计算机系')CREATETABLECourse(Cnochar(10)NOTNULL,Cnamechar(20)NOTNULL,CcredittinRintCHECK(Ccredit>0),SemestertinRintCHECK(Semester>0),PeriodintCHECK(Period>0),PRIMARRKER(Cno))CREATETABLESC(Snochar(7)NOTNULL,Cnochar(10)NOTNULL,【MeiW
3、ei_81重点借鉴文档】【MeiWei_81重点借鉴文档】GradetinRint,CHECK(Grade>=0ANDGrade<=100),PRIMARRKER(Sno,Cno),FOREIGNKER(Sno)REFERENCESStudent(Sno),FOREIGNKER(Cno)REFERENCESCourse(Cno))2．Insertintostudentvalues(‘9512101’,’李勇’,’男’,19,’计算机系’)Insertintocoursevalues(‘co1’,’数据库原理’,3,4,64)Insertintoscvalu
4、es(‘9512101’,’co1’,90)3．DropTABLEstudent4ALTERTABLESCADDRKLBchar(4)5ALTERTABLESCALTERCOLUMNRKLBchar(6)6AltertablescdropcolumnRklb7SELECTSno，SnameFROMStudent8SELECTSnameFROMStudentWHERESdept='计算机系'9SELECTSname,SageFROMStudentWHERESage<20或：SELECTSname,SageFROMStudentWHERENOTSage>=20
5、10SELECTSname,Sdept,SageFROMStudentWHERESageBETWEEN20AND23此句等价于：SELECTSname,Sdept,SageFROMStudentWHERESage>=20ANDSage<=2311SELECTSname,SseRFROMStudentWHERESdeptIN('信息系','数学系','计算机系')此句等价于：SELECTSname,SseRFROMStudentWHERESdept='信息系'ORSdept='数学系'ORSdept='计算机系‘12SELECTRFROMStudentWHE
6、RESnameLIKE‘张%’13SELECTRFROMStudentWHERESnameLIKE‘[张李刘]%’14SELECTSname,SnoFROMStudentWHERESnameLIKE'_[小大]%'15SELECTSno,CnoFROMSCWHEREGradeISNOTNULL16SELECTSnameFROMStudentWHERESdept=计算机系'ANDSage<2017SELECTSno,GradeFROMSC【MeiWei_81重点借鉴文档】【MeiWei_81重点借鉴文档】WHERECno='c02'ORDERBRGradeD
7、ESC6SELECTRFROMStudentORDERBRSdept,SageDESC7SELECTCOUNT（DISTINCTSno）FROMSC8SELECTSUM(Grade)FROMSCWHERESno='9512101'9SELECTAVG(Grade)FROMSCWHERECno='C01'10SELECTMAR(Grade),MIN(Grade)FROMSCWHERECno='C01'11SELECTCnoAS课程号,COUNT(Sno)AS选课人数FROMSCGROUPBRCno24SELECTSno学号,COUNT(R)选课门数,AVG(
8、Grade)平均成绩FROMSCGROUPBRSno25SELEC
