资源描述：
《学生基本信息数据库代码》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、学生基本信息数据库代码createdatabasestudjcusestudjccreatetableadminUsers(adminIDintIDentity(1,1)primarykey,adminNamevarchar(20),adminPwdvarchar(20))insertintoadminUsersvalues('wyx','1234')insertintoadminUsersvalues('sql','abcd')createtablezhuanye(zhuanyeIDintidentity(1,1)pr
2、imarykey,zhuanyeNamevarchar(20))insertintozhuanyevalues('计算机应用技术')insertintozhuanyevalues('软件技术')insertintozhuanyevalues('计算机网络技术')createtableclass(classIDintidentity(1,1)primarykey,zhuanyeIDintforeignkeyreferenceszhuanye(zhuanyeID),classNamevarchar(20))insertint
3、oclassvalues(1,'计A081')insertintoclassvalues(1,'计B081')insertintoclassvalues(2,'软件A081')insertintoclassvalues(2,'软件A091')insertintoclassvalues(3,'网络A081')insertintoclassvalues(2,'网络A091')createtablezhengzhimm(mmIDintprimarykey,mmNamechar(4))insertintozhengzhimmva
4、lues(1,'党员')insertintozhengzhimmvalues(2,'团员')insertintozhengzhimmvalues(3,'群众')createtablestudUsers(studNumchar(10)primarykey,studNamevarchar(20),studSexchar(2),zhuanyeIDintforeignkeyreferenceszhuanye(zhuanyeID),classIDintforeignkeyreferencesclass(classID),mmIDi
5、ntforeignkeyreferenceszhengzhimm(mmID))insertintostudUsersvalues('2008010101','张凤','女','1','1',2)insertintostudUsersvalues('2008010102','李立芬','女','1','2',2)insertintostudUsersvalues('2008010201','王一','男','2','3',1)altertablestudUsersaddcheck(studSex='男'orstudSex=
6、'女')createtablejangli(jlIDintidentity(1,1)primarykey,jlNamevarchar(50),jlDanweivarchar(50),jlGradechar(10))altertablejangliaddunique(jlName,jlDanwei)insertintojanglivalues('三好学生','水利学院','院级')insertintojanglivalues('优秀团员','水利学院','院级')insertintojanglivalues('一等奖学金'
7、,'水利学院','院级')createtablechufa(cfIDintidentity(1,1)primarykey,cfNamevarchar(50),cfDanweivarchar(50),cfGradechar(10))insertintochufavalues('警告','水利学院','院级')insertintochufavalues('留校察看','水利学院','院级')createtablestudjl(studjlIDintidentity(1,1)primarykey,studNumchar(10)
8、foreignkeyreferencesstudUsers(studNum),jlIDintforeignkeyreferencesjangli(jlID),jlXueqichar(1)notnull,jlTimedateTime,jlCailiaovarchar(50)null,jlYouxiaochar(1)de
