资源描述：
《实验三创建数据库和数据表实验报告》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。
1、实验三1、建立数据库university2、建表：1)Student:USE[university]GOSETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLE[dbo].[student]([snum][nchar](6)COLLATEChinese_PRC_CI_ASNOTNULL,[sname][nchar](10)COLLATEChinese_PRC_CI_ASNULL,[sex][nchar](2)COLLATEChinese_PRC_CI_ASNULL,[dept][nchar]
2、(20)COLLATEChinese_PRC_CI_ASNULL,[birthday][datetime]NULL,[telephone][nchar](12)COLLATEChinese_PRC_CI_ASNULL,CONSTRAINT[PK_student]PRIMARYKEYCLUSTERED([snum]ASC)WITH(PAD_INDEX=OFF,IGNORE_DUP_KEY=OFF)ON[PRIMARY])ON[PRIMARY]GOALTERTABLE[dbo].[student]WITHCHECKADDCONSTRAINT[
3、CK_sex]CHECK(([sex]='女'OR[sex]='男'))GOALTERTABLE[dbo].[student]CHECKCONSTRAINT[CK_sex]GOALTERTABLE[dbo].[student]WITHCHECKADDCONSTRAINT[CK_snum]CHECK((substring([snum],(1),(1))='S'))GOALTERTABLE[dbo].[student]CHECKCONSTRAINT[CK_snum]GOALTERTABLE[dbo].[student]WITHCHECKADD
4、CONSTRAINT[CK_tel]CHECK((isnumeric(substring([telephone],(1),(3)))=(1)ANDisnumeric(substring([telephone],(5),(8)))=(1)))GOALTERTABLE[dbo].[student]CHECKCONSTRAINT[CK_tel]视图：1)Course:USE[university]GOSETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLE[dbo].[course]([cnum]
5、[nchar](6)COLLATEChinese_PRC_CI_ASNOTNULL,[cname][nchar](20)COLLATEChinese_PRC_CI_ASNULL,[credits][smallint]NULL,[descr][nchar](10)COLLATEChinese_PRC_CI_ASNULL,[dept][nchar](20)COLLATEChinese_PRC_CI_ASNULL,[textbook][nchar](40)COLLATEChinese_PRC_CI_ASNULL,CONSTRAINT[PK_co
6、urse]PRIMARYKEYCLUSTERED([cnum]ASC)WITH(PAD_INDEX=OFF,IGNORE_DUP_KEY=OFF)ON[PRIMARY])ON[PRIMARY]GOALTERTABLE[dbo].[course]WITHCHECKADDCONSTRAINT[FK_course_course]FOREIGNKEY([cnum])REFERENCES[dbo].[course]([cnum])GOALTERTABLE[dbo].[course]CHECKCONSTRAINT[FK_course_course]G
7、OALTERTABLE[dbo].[course]WITHCHECKADDCONSTRAINT[CK_course]CHECK((substring([cnum],(1),(1))='c'))GOALTERTABLE[dbo].[course]CHECKCONSTRAINT[CK_course]GOALTERTABLE[dbo].[course]WITHCHECKADDCONSTRAINT[CK_course_1]CHECK(([credits]>(0)AND[credits]<(8)))GOALTERTABLE[dbo].[course
8、]CHECKCONSTRAINT[CK_course_1]1)Sc:USE[university]GOSETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREA
