实验三 创建数据库和数据表 实验报告.doc

实验三 1、建立数据库 university 2、建表: 1)S tudent: USE [university] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo] . [student] ( [snum] [nchar] (6) COLLATE Chinese_PRC_CI_AS NOT NULL, [sname] [nchar] ( 10 ) COLLATE Chinese_PRC_CI_AS NULL, [sex] [nchar] (2) COLLATE Chinese_PRC_CI_AS NULL, [dept] [nchar] ( 20 ) COLLATE Chinese_PRC_CI_AS NULL, [birthday] [datetime] NULL, [telephone] [nchar] ( 12 ) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_student] PRIMARY KEY CLUSTERED ( [snum] ASC ) WITH ( PAD_INDEX = OFF , IGNORE_DUP_KEY = OFF ) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo] . [student] WITH CHECK ADD CONSTRAINT [CK_sex] CHECK (( [sex] ='女' OR [sex] ='男' )) GO ALTER TABLE [dbo] . [student] CHECK CONSTRAINT [CK_sex] GO ALTER TABLE [dbo] . [student] WITH CHECK ADD CONSTRAINT [CK_snum] CHECK (( substring ( [snum] ,( 1 ),( 1 ))= 'S' )) GO ALTER TABLE [dbo] . [student] CHECK CONSTRAINT [CK_snum] GO ALTER TABLE [dbo] . [student] WITH CHECK ADD CONSTRAINT [CK_tel] CHECK (( isnumeric ( substring ( [telephone] ,( 1 ),( 3 )))=( 1) AND isnumeric ( substring ( [telephone] ,( 5 ),( 8 )))=( 1 ))) GO ALTER TABLE [dbo] . [student] CHECK CONSTRAINT [CK_tel] 视图: 2) Course: USE [university] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo] . [course] ( [cnum] [nchar] (6) COLLATE Chinese_PRC_CI_AS NOT NULL, [cname] [nchar] ( 20 ) COLLATE Chinese_PRC_CI_AS N