学生信息管理数据库的构建项目概述第一章SQL Server数据库基础实训1.1项目介绍学生信息管理工作是整个学校信息化管理的核心和基础。

学校每年都有新生入学，毕业生离校，同时还有其他针对学生的各种人事变动，面对如此庞大的信息量，手工处理的方式已经难以适应学校现代化管理的要求。

1.1.1数据需求分析需求分析是整个数据库设计过程的基础，要收集数据库所有用户的信息内容和处理要求，并加以规格化和分析。

数据流图和数据字典是描述用户需求的重要工具。

数据流图描述了数据的来远和去向，以及所经过的处理；数据字典是对系统所需要处理的数据结构的进一步的描述。

学生信息管理系统的数据字典和数据流图包括以下内容。

1.1.2系统的基本数据字典学生管理信息系统的基本数据字典的内容如下：学生基本信息：学号、姓名、性别、出生日期、入学时间、籍贯、电话、联系地址等。

学籍基本信息：学籍代码、入学时间、学历、毕业中学等。

院系基本信息：院系代码、院系名称等。

班级基本信息：班级代码、班级名称等。

奖罚基本信息：代码、名称、时间、是否生效、描述等。

社团活动基本信息：社团代码，学号，职务，加入时间等。

社团基本信息：社团代码、社团名称、创办时间等。

身体状况基本信息：体检代码，眼科，鼻科，胸透，身高，体重，是否合格等。

活动基本信息：代码、名称等。

举办活动信息：代码、举办地点、举办时间等。

接受奖罚基本信息：代码、记录时间等等。

1.1.3 系统的基本数据流图数据流图是从数据和对数据的加工处理的角度来描述系统的图形。

数据流图的基本组成元素如下图所示：数据存储图3-1数据流图的基本组成元素学生信息管理系统的基本数据流图如下所示：身体状况图3-2学生信息管理系统的基本数据流图学生学籍信息图3-3学生信息管理系统的基本数据流图活动信息图3-4 学生信息管理系统的基本数据流图社团信息图3-4 学生信息管理系统的基本数据流图1.2概念结构设计概念结构设计是把用户的信息要求统一到一个整体逻辑结构中，此结构能够表达用户的要求，是一个独立与任何DBMS软件和硬件的概念模型。

概念结构设计是以需求分析所得到的系统数据字典和系统数据流图为输入，经过加工处理后，输出系统的实体、联系模型（ERM）。

实体、联系模型（ERM）图的基本组成元素如下图所示：图3-5 实体、联系模型（ERM）图的基本组成元素图实体、联系模型（ERM）是概念设计阶段描述概念结构模型的只要设计工具，学生信息管理系统的E-R图包括以下内容。

1. 2.1学生实体的E-R图1. 2.2学籍实体的E-R图1.2.3院系实体的E-R图1. 2.4班级实体的E-R图1. 2.5奖罚实体的E-R图1. 2.6社团实体的E-R图1. 2.7体检实体的E-R图1. 2.8学生实体的E-R图1. 2.9各实体关系的E-R图1. 3数据库逻辑结构设计现在需要将上面的数据库概念结构转化为SQL Server 2000数据库系统所支持的实际数据模型，也就是数据库的逻辑结构。

在上面的实体以及实体之间关系的基础上，开成数据库中的表格以及各个表格之间的关系逻辑结构设计是将上一步所得到的概念模型转换为SQL server所支持的数据模型，并对其进行优化。

逻辑结构设计是以概念结构设计所得到系统的实体.，联系模型为输入，经过转换处理后，输出系统的关系数据结构（表结构）通过系统的实体，联系模型进行系统的关系数据结构（表结构）转换总体原则如下：1）E-R图中的实体和有属性的联系转换成关系2）E-R图中的属性转换成关系的属性1. 3.1 student（学生基本信息表）学生（学号,姓名,性别,出生日期,入学时间,籍贯,电话,联系地址,班号）1. 3.2 class（班级基本信息表）班级（班级代码、班级名称，院系）1. 3.3 department（院系基本信息表）院系（院系代码、院系名称）1. 3.4 Corporation（社团基本信息表）社团(社团代码、社团名称、创办时间)1. 3.5 Corpoactiv（社团活动基本信息表）社团活动（社团代码，学号，职务，加入时间）1.3.6 Awapunis（奖惩基本信息表）奖惩（奖惩代码、名称、备注、是否生效）1. 3.7accAwapunis（接受奖惩基本信息表）接受奖惩（奖惩代码、学号、生效时间）1. 3.8 activities（活动基本信息表）晚会（代码、名称）1. 3.9 inactivities（举办活动基本信息表）举办活动（活动代码、系代码、地点、时间）1. 3.10 studchange（学籍基本信息表）学籍（学籍代码、学号、入学时间、学历、毕业中学、备注）1. 3.11 healthy（身体状况基本信息表）身体状况（体检代码，眼科，鼻科，身高，体重，血压，胸透，肝炎，身体是否合格）1. 3.12学生信息管理数据库逻辑关系图1. 4生成脚本IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'Student information management system')DROP DA TABASE [Student information management system]GOCREA TE DA TABASE [Student information management system] ON (NAME = N'Student information management system_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\Student information management system_Data.MDF' , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'Student information management system_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\Student information management system_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)COLLA TE Chinese_PRC_CI_ASGOexec sp_dboption N'Student information management system', N'autoclose', N'true'GOexec sp_dboption N'Student information management system', N'bulkcopy', N'false'GOexec sp_dboption N'Student information management system', N'trunc. log', N'true'GOexec sp_dboption N'Student information management system', N'torn page detection', N'true' GOexec sp_dboption N'Student information management system', N'read only', N'false'GOexec sp_dboption N'Student information management system', N'dbo use', N'false'GOexec sp_dboption N'Student information management system', N'single', N'false'GOexec sp_dboption N'Student information management system', N'autoshrink', N'true'GOexec sp_dboption N'Student information management system', N'ANSI null default', N'false' GOexec sp_dboption N'Student information management system', N'recursive triggers', N'false' GOexec sp_dboption N'Student information management system', N'ANSI nulls', N'false'GOexec sp_dboption N'Student information management system', N'concat null yields null', N'false'GOexec sp_dboption N'Student information management system', N'cursor close on commit', N'false' GOexec sp_dboption N'Student information management system', N'default to local cursor', N'false' GOexec sp_dboption N'Student information management system', N'quoted identifier', N'false'GOexec sp_dboption N'Student information management system', N'ANSI warnings', N'false'GOexec sp_dboption N'Student information management system', N'auto create statistics', N'true' GOexec sp_dboption N'Student information management system', N'auto update statistics', N'true' GOuse [Student information management system]GOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[FK_accA wapunis_A wapunis]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)ALTER TABLE [dbo].[accA wapunis] DROP CONSTRAINT FK_accA wapunis_A wapunisGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[FK_Corpoactiv_Corporation]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)ALTER TABLE [dbo].[Corpoactiv] DROP CONSTRAINT FK_Corpoactiv_CorporationGOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_inactivities_activities]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)ALTER TABLE [dbo].[inactivities] DROP CONSTRAINT FK_inactivities_activitiesGOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_student_class]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)ALTER TABLE [dbo].[student] DROP CONSTRAINT FK_student_classGOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_class_department]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)ALTER TABLE [dbo].[class] DROP CONSTRAINT FK_class_departmentGOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_inactivities_department]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)ALTER TABLE [dbo].[inactivities] DROP CONSTRAINT FK_inactivities_departmentGOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_student_healthy]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)ALTER TABLE [dbo].[student] DROP CONSTRAINT FK_student_healthyGOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_accA wapunis_student]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)ALTER TABLE [dbo].[accA wapunis] DROP CONSTRAINT FK_accA wapunis_studentGOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Corpoactiv_student]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)ALTER TABLE [dbo].[Corpoactiv] DROP CONSTRAINT FK_Corpoactiv_studentGOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_studchange_student]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)ALTER TABLE [dbo].[studchange] DROP CONSTRAINT FK_studchange_studentGOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[studentinfor]') and OBJECTPROPERTY(id, N'IsView') = 1)drop view [dbo].[studentinfor]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[students_all]') and OBJECTPROPERTY(id, N'IsView') = 1)drop view [dbo].[students_all]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[A wapunis]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[A wapunis]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Corpoactiv]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[Corpoactiv]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Corporation]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[Corporation]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[accA wapunis]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[accA wapunis]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[activities]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[activities]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[class]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[class]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[department]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[department]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[healthy]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[healthy]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[inactivities]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[inactivities]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[studchange]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[studchange]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[student]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[student]GOif not exists (select * from master.dbo.syslogins where loginname = N'111')BEGINdeclare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'stu',@loginlang = N'简体中文'if @logindb is null or not exists (select * from master.dbo.sysdatabases where name =@logindb)select @logindb = N'master'if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')select @loginlang = @@languageexec sp_addlogin N'111', null, @logindb, @loginlangENDGOif not exists (select * from master.dbo.syslogins where loginname = N'I12\Administrator') exec sp_grantlogin N'I12\Administrator'exec sp_defaultdb N'I12\Administrator', N'master'exec sp_defaultlanguage N'I12\Administrator', N'简体中文'GOif not exists (select * from master.dbo.syslogins where loginname = N'teaching')BEGINdeclare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'master', @loginlang = N'简体中文'if @logindb is null or not exists (select * from master.dbo.sysdatabases where name =@logindb)select @logindb = N'master'if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')select @loginlang = @@languageexec sp_addlogin N'teaching', null, @logindb, @loginlangENDGOif not exists (select * from master.dbo.syslogins where loginname = N'studentinfor')BEGINdeclare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Student information management system', @loginlang = N'简体中文'if @logindb is null or not exists (select * from master.dbo.sysdatabases where name =@logindb)select @logindb = N'master'if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')select @loginlang = @@languageexec sp_addlogin N'studentinfor', null, @logindb, @loginlangENDGOexec sp_addsrvrolemember N'I12\Administrator', sysadminGOCREA TE TABLE [dbo].[A wapunis] ([code] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NOT NULL ,[name] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NOT NULL ,[addition] [varchar] (50) COLLA TE Chinese_PRC_CI_AS NULL ,[gieffect] [varchar] (10) COLLA TE Chinese_PRC_CI_AS NULL) ON [PRIMARY]GOCREA TE TABLE [dbo].[Corpoactiv] ([corpo_code] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NOT NULL ,[stude_code] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NOT NULL ,[title] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NULL ,[intime] [datetime] NULL) ON [PRIMARY]GOCREA TE TABLE [dbo].[Corporation] ([code] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NOT NULL ,[name] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NULL ,[intime] [datetime] NULL) ON [PRIMARY]GOCREA TE TABLE [dbo].[accA wapunis] ([awapu_code] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NOT NULL ,[stude_code] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NOT NULL ,[intime] [datetime] NULL) ON [PRIMARY]GOCREA TE TABLE [dbo].[activities] ([code] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NOT NULL ,[name] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NULL) ON [PRIMARY]GOCREA TE TABLE [dbo].[class] ([code] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NOT NULL ,[name] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NULL ,[depar_code] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY]GOCREA TE TABLE [dbo].[department] ([code] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NOT NULL ,[name] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NULL) ON [PRIMARY]GOCREA TE TABLE [dbo].[healthy] ([code] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NOT NULL ,[eye] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NULL ,[nose] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NULL ,[height] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NULL ,[weight] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NULL ,[blood] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NULL ,[perspective] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NULL ,[hepatitis] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NULL ,[status] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NULL) ON [PRIMARY]GOCREA TE TABLE [dbo].[inactivities] ([activ_code] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NOT NULL , [depar_code] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NOT NULL , [adress] [varchar] (50) COLLA TE Chinese_PRC_CI_AS NULL ,[intime] [datetime] NULL) ON [PRIMARY]GOCREA TE TABLE [dbo].[studchange] ([code] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NOT NULL ,[stude_code] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NOT NULL ,[name] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NULL ,[intime] [datetime] NULL ,[midschool] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NULL ,[addition] [varchar] (50) COLLA TE Chinese_PRC_CI_AS NULL) ON [PRIMARY]GOCREA TE TABLE [dbo].[student] ([code] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NOT NULL ,[name] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NULL ,[sex] [varchar] (2) COLLA TE Chinese_PRC_CI_AS NULL ,[healt_code] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NULL ,[birthday] [datetime] NULL ,[adress] [varchar] (50) COLLA TE Chinese_PRC_CI_AS NULL ,[telephone] [varchar] (12) COLLA TE Chinese_PRC_CI_AS NULL ,[class_code] [varchar] (20) COLLA TE Chinese_PRC_CI_AS NOT NULL , [addition] [varchar] (50) COLLA TE Chinese_PRC_CI_AS NULL ,[intime] [datetime] NULL) ON [PRIMARY]GOALTER TABLE [dbo].[A wapunis] WITH NOCHECK ADDCONSTRAINT [PK_A wapunis] PRIMARY KEY CLUSTERED([code]) ON [PRIMARY]GOALTER TABLE [dbo].[Corporation] WITH NOCHECK ADDCONSTRAINT [PK_Corporation] PRIMARY KEY CLUSTERED([code]) ON [PRIMARY]GOALTER TABLE [dbo].[activities] WITH NOCHECK ADDCONSTRAINT [PK_activities] PRIMARY KEY CLUSTERED([code]) ON [PRIMARY]GOALTER TABLE [dbo].[class] WITH NOCHECK ADDCONSTRAINT [PK_class] PRIMARY KEY CLUSTERED([code]) ON [PRIMARY]GOALTER TABLE [dbo].[department] WITH NOCHECK ADDCONSTRAINT [PK_department] PRIMARY KEY CLUSTERED([code]) ON [PRIMARY]GOALTER TABLE [dbo].[healthy] WITH NOCHECK ADDCONSTRAINT [PK_healthy] PRIMARY KEY CLUSTERED([code]) ON [PRIMARY]GOALTER TABLE [dbo].[studchange] WITH NOCHECK ADDCONSTRAINT [PK_studchange] PRIMARY KEY CLUSTERED([code]) ON [PRIMARY]GOALTER TABLE [dbo].[student] WITH NOCHECK ADDCONSTRAINT [PK_student] PRIMARY KEY CLUSTERED([code]) ON [PRIMARY]GOCREA TE INDEX [IX_accA wapunis] ON [dbo].[accA wapunis]([awapu_code]) ON [PRIMARY]GOCREA TE INDEX [IX_inactivities] ON [dbo].[inactivities]([activ_code]) ON [PRIMARY] GOALTER TABLE [dbo].[Corpoactiv] ADDCONSTRAINT [FK_Corpoactiv_Corporation] FOREIGN KEY([corpo_code]) REFERENCES [dbo].[Corporation] ([code]),CONSTRAINT [FK_Corpoactiv_student] FOREIGN KEY([stude_code]) REFERENCES [dbo].[student] ([code])GOALTER TABLE [dbo].[accA wapunis] ADDCONSTRAINT [FK_accA wapunis_A wapunis] FOREIGN KEY ([awapu_code]) REFERENCES [dbo].[A wapunis] ([code]),CONSTRAINT [FK_accA wapunis_student] FOREIGN KEY([stude_code]) REFERENCES [dbo].[student] ([code])GOALTER TABLE [dbo].[class] ADDCONSTRAINT [FK_class_department] FOREIGN KEY([depar_code]) REFERENCES [dbo].[department] ([code])GOALTER TABLE [dbo].[inactivities] ADDCONSTRAINT [FK_inactivities_activities] FOREIGN KEY([activ_code]) REFERENCES [dbo].[activities] ([code]),CONSTRAINT [FK_inactivities_department] FOREIGN KEY ([depar_code]) REFERENCES [dbo].[department] ([code])GOALTER TABLE [dbo].[studchange] ADDCONSTRAINT [FK_studchange_student] FOREIGN KEY([stude_code]) REFERENCES [dbo].[student] ([code])GOALTER TABLE [dbo].[student] ADDCONSTRAINT [FK_student_class] FOREIGN KEY([class_code]) REFERENCES [dbo].[class] ([code]),CONSTRAINT [FK_student_healthy] FOREIGN KEY([healt_code]) REFERENCES [dbo].[healthy] ([code])GOSET QUOTED_IDENTIFIER ONGOSET ANSI_NULLS ONGOCREA TE VIEW dbo.studentinforASSELECT dbo.student.code AS 学号, AS 姓名,dbo.A AS 奖惩名称, AS 社团名称,dbo.Corpoactiv.title AS 社团职务, dbo.healthy.status AS 身体状况FROM dbo.A wapunis INNER JOINdbo.accA wapunis ONdbo.A wapunis.code = dbo.accA wapunis.awapu_code INNER JOINdbo.student ON dbo.accA wapunis.stude_code = dbo.student.code INNER JOINdbo.Corporation INNER JOINdbo.Corpoactiv ON dbo.Corporation.code = dbo.Corpoactiv.corpo_code ONdbo.student.code = dbo.Corpoactiv.stude_code INNER JOINdbo.healthy ON dbo.student.healt_code = dbo.healthy.codeGOSET QUOTED_IDENTIFIER OFFGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_NULLS ONGOCREA TE VIEW dbo.students_allASSELECT dbo.healthy.status AS 健康程度, AS 学历, dbo.student.code AS 学号, AS 学生姓名,dbo.Corpoactiv.title AS 社团职务, AS 社团名称,dbo.Corporation.intime AS 建设时间, AS 班级, AS 院系名称, dbo.inactivities.adress AS 活动地址, AS 晚会名称, dbo.accA wapunis.intime AS 接受奖罚日期, dbo.A AS 奖罚名称FROM dbo.student INNER JOINdbo.class ON dbo.student.class_code = dbo.class.code INNER JOINdbo.department ON dbo.class.depar_code = dbo.department.code INNER JOIN dbo.Corpoactiv ON dbo.student.code = dbo.Corpoactiv.stude_code INNER JOIN dbo.Corporation ONdbo.Corpoactiv.corpo_code = dbo.Corporation.code INNER JOINdbo.inactivities ONdbo.department.code = dbo.inactivities.depar_code INNER JOINdbo.studchange ON dbo.student.code = dbo.studchange.stude_code INNER JOIN dbo.activities ON dbo.inactivities.activ_code = dbo.activities.code INNER JOIN dbo.accA wapunis ONdbo.student.code = dbo.accA wapunis.stude_code INNER JOINdbo.A wapunis ONdbo.accA wapunis.awapu_code = dbo.A wapunis.code INNER JOINdbo.healthy ON dbo.student.healt_code = dbo.healthy.codeGOSET QUOTED_IDENTIFIER OFFGOSET ANSI_NULLS ONGO第二章教学管理信息系统数据库管理1.案例实践1.1案例实验数据1.1.1接受奖罚信息表实验数据表5-1接受奖罚信息表实验数据1.1.2 活动信息表实验数据表5-1活动信息表实验数据1.1.3 奖罚信息表实验数据表5-1奖罚信息表实验数据1.1.4 班级信息表实验数据表5-1班级信息表实验数据1.1.5 参加社团活动信息表实验数据表5-1参加社团活动信息表实验数据1.1.6 社团信息表实验数据表5-1社团信息表实验数据1.1.7 院系信息表实验数据表5-1院系信息表实验数据1.1.8 身体健康信息表实验数据表5-1身体健康信息表实验数据1.1.9 活动举办信息表实验数据表5-1活动举办信息表实验数据1.1.10 学籍变动信息表实验数据表5-1学籍变动信息表实验数据1.1.11 学生信息表实验数据表5-1学生信息表实验数据第三章教学管理信息系统数据库实施1.项目实践1.1数据库的创建1.1.1 分析参照2.5.1 数据库定义语句，使用Transact-SQL语言在查询分析器中进行教学管理信息系统数据库的创建。