资源描述：
《数据库学生选课系统代码设计》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、北京理工大学珠海学院商学院课程设计完整的SQL语句createdatabaseS_CuseS_CcreatetableStudent(StuIDchar(8)notnullprimarykey,StuNamevarchar(10)notnull,Telvarchar(13),Sagesmallint,Ssexchar(2)default'男'check(Ssexin('男','女')),Semailvarchar(20),Sintdaydatetime,GradeIDchar(6)notnull,Snationvarcha
2、r(20),Saddvarchar(40),)createtableGrade(GradeIDchar(6)notnullprimarykey,GNamevarchar(20)notnull,GNumintnotnull,Gassistvarchar(10),Gdeptvarchar(20),Gacademyvarchar(20))select*fromGradecreatetableTeacher(TIDchar(4)notnullprimarykey,TNamevarchar(10)notnull,Temailvarc
3、har(20),Tsexchar(2),Tnationvarchar(20),Taddvarchar(20),Ttelvarchar(13))createtableCourse(CIDchar(6)notnullprimarykey,CNamevarchar(20)notnull,Cnumvarchar(2),Ccapavarchar(3),Cdatedatetime,Croomchar(5),北京理工大学珠海学院商学院课程设计C_XKLvarchar(6))createtableManager(MIDchar(6)not
4、nullprimarykey,MNamevarchar(10)notnull,Msexchar(2),Mtelvarchar(13),Maddvarchar(40),Memilvarchar(20))createtableSC(SCIDchar(5)notnullprimarykey,StuIDchar(8)notnull,TIDchar(4),CIDchar(6)notnull,Creditsmallint,check(Creditbetween0and100),foreignkey(StuID)referencesSt
5、udent(StuID),foreignkey(TID)referencesTeacher(TID),foreignkey(CID)referencesCourse(CID))insertintoStudentvalues('09080401','乐乐','13750034866','20','女','hiiss@123.com','2010-09-20','090804','汉','广东河源')insertintoStudentvalues('09070101','陈红','13750034806','20','女','
6、764223@sina.com','2010-09-20','090701','汉','广东佛山')insertintoStudentvalues('09070201','大树','13750034816','20','男','763423@sina.com','2010-09-20','090702','回','广东汕头')insertintoStudent(StuID,StuName,Tel,Sage,Semail,Sintday,GradeID,Snation,Sadd)values('08060201','李刚',
7、'13750034826','21','fdhftg@sina.com','2009-09-20','080602','汉','山东烟台')insertintoStudent(StuID,StuName,Tel,Sage,Semail,Sintday,GradeID,Snation,Sadd)values('09080202','大鹰','13750034836','20','dauyi@sina.com','2008-10-10','090802','汉','山西太原')insertintoStudent(StuID,S
8、tuName,Tel,Sage,Semail,Sintday,GradeID,Snation,Sadd)values('09080402','大山','13750034846','22','ksjguuu@sina.com','2008-10-10','090804','汉','陕西西安')insert
