《数据库原理及应用》课件_第2章 关系数据库 2.pptVIP

习题返回本章首页习题返回本章首页*CREATEDATABASEJXGLGOusejxgldroptablescdroptablecoursedroptablestudentCreateTableStudent(SnoCHAR(6)NOTNULLPRIMARYKEY(Sno),SnCHAR(6),sexCHAR(2)DEFAULT男CHECK(sex=男ORsex=女),ageSMALLINTCHECK(age=15ANDage=45),deptCHAR(2));CreateTableCourse(CnoCHAR(2)NOTNULLPRIMARYKEY(Cno),CnVARCHAR(20),CpnoCHAR(2),CtSMALLINT);CreateTableSC(SnoCHAR(6)NOTNULLCONSTRAINTS_FFOREIGNKEYREFERENCESStudent(Sno),CnoCHAR(2)NOTNULL,SCORESMALLINTCHECK((SCOREISNULL)OR(SCOREBETWEEN0AND100)),PRIMARYKEY(Sno,Cno),FOREIGNKEY(Cno)REFERENCESCourse(Cno));INSERTINTOStudentVALUES(200401,李立勇,男,20,CS);INSERTINTOStudentVALUES(200402,刘蓝,女,19,IS);INSERTINTOStudentVALUES(200403,周小花,女,18,MA);INSERTINTOStudentVALUES(200404,张立伟,男,19,IS);INSERTINTOCourseVALUES(C1,数据库,C3,4);INSERTINTOCourseVALUES(C2,离散数学,null,2);INSERTINTOCourseVALUES(C3,操作系统,C4,3);INSERTINTOCourseVALUES(C4,数据结构,C2,4);INSERTINTOSCVALUES(200401,C1,85);INSERTINTOSCVALUES(200401,C2,92);INSERTINTOSCVALUES(200401,C3,84);INSERTINTOSCVALUES(200402,C2,94);INSERTINTOSCVALUES(200403,C3,83);*CREATEDATABASEJXGLGOusejxgldroptablescdroptablecoursedroptablestudentCreateTableStudent(SnoCHAR(6)NOTNULLPRIMARYKEY(Sno),SnCHAR(6),sexCHAR(2)DEFAULT男CHECK(sex=男ORsex=女),ageSMALLINTCHECK(age=15ANDage=45),deptCHAR(2));CreateTableCourse(CnoCHAR(2)NOTNULLPRIMARYKEY(Cno),CnVARCHAR(20),CpnoCHAR(2),CtSMALLINT);CreateTableSC(SnoCHAR(6)NOTNULLCONSTRAINTS_FFOREIGNKEYREFERENCESStudent(Sno),CnoCHAR(2)NOTNULL,SCORESMALLINTCHECK((SCOREISNULL)OR(SCOREBETWEEN0AND100)),PRIMARYKEY(Sno,Cno),FOREIGNKEY(Cno)REFERENCESCourse(Cno));INSERTINTOStudentVALUES(200401,李立勇,男,20,CS);INSERTINTOStudentVALUES(200402,刘蓝,女,19,IS);INSERTINTOStudentVALUES(200403,周小花,女,18,MA);INSERTINTOStudentVALUES(200404,张立伟,男,19,IS);INSERTINT