教學(xué)管理信息系統(tǒng)數(shù)據(jù)庫(kù)的構(gòu)建與設(shè)計(jì)_圖文

1、教學(xué)管理信息系統(tǒng)數(shù)據(jù)庫(kù)的構(gòu)建與設(shè)計(jì)項(xiàng)目概述 第一章教學(xué)管理信息系統(tǒng)數(shù)據(jù)庫(kù)設(shè)計(jì)1.項(xiàng)目介紹教學(xué)管理管理信息系統(tǒng)的基本業(yè)務(wù)需求主要包括以下內(nèi)容:學(xué)生成績(jī)管理包括:各院系的教務(wù)人員完成學(xué)生學(xué)籍注冊(cè)、畢業(yè)、學(xué)籍異常處理,各授課教師完成所講授課程成績(jī)的錄入,然后由教務(wù)人員進(jìn)行學(xué)生成績(jī)的審核認(rèn)可。學(xué)生選課管理包括:學(xué)生根據(jù)開(kāi)設(shè)課程和培養(yǎng)計(jì)劃選擇本學(xué)期所修課程,教務(wù)人員對(duì)學(xué)生所選課程進(jìn)行確認(rèn)處理。教學(xué)調(diào)度安排包括:教務(wù)人員根據(jù)本學(xué)期所開(kāi)課程、教師上課情況以及學(xué)生選課情況完成安排課、調(diào)課、教師管理。1.1 數(shù)據(jù)需求分析需求分析是整個(gè)數(shù)據(jù)庫(kù)設(shè)計(jì)過(guò)程的基礎(chǔ),要收集數(shù)據(jù)庫(kù)所有用戶的信息內(nèi)容和處理要求,并加以規(guī)格化和

2、分析。數(shù)據(jù)流圖和數(shù)據(jù)字典是描述用戶需求的重要工具。數(shù)據(jù)流圖描述了數(shù)據(jù)的來(lái)遠(yuǎn)和去向,以及所經(jīng)過(guò)的處理;數(shù)據(jù)字典是對(duì)系統(tǒng)所需要處理的數(shù)據(jù)結(jié)構(gòu)的進(jìn)一步的描述。教學(xué)管理信息系統(tǒng)的數(shù)據(jù)字典和數(shù)據(jù)流圖包括以下內(nèi)容。教學(xué)管理信息系統(tǒng)的基本數(shù)據(jù)字典的內(nèi)容如下:學(xué)生基本信息:包括的數(shù)據(jù)項(xiàng)有:學(xué)號(hào)、班級(jí)代碼、姓名、性別、政治面貌、職務(wù)、籍貫、出生日期、家庭住址等。課程基本信息:包括的數(shù)據(jù)項(xiàng)有:課程代碼、課程名稱、講授課時(shí)、課程學(xué)分、人數(shù)等。教師基本信息:包括的數(shù)據(jù)項(xiàng)有:教師編碼、教師姓名、性別、所學(xué)專業(yè)、職稱、籍貫、出生日期、家庭住址等。教室基本信息:包括的數(shù)據(jù)項(xiàng)有:教室編碼、教室類型、教室容量等。系別基本信息:

3、包括的數(shù)據(jù)項(xiàng)有:系代碼、系名稱、系地址、系電話等。專業(yè)基本信息:包括的數(shù)據(jù)項(xiàng)有:專業(yè)代碼、專業(yè)名稱、專業(yè)性質(zhì)、專業(yè)簡(jiǎn)介、所授學(xué)位等。成績(jī)基本信息:包括的數(shù)據(jù)項(xiàng)有:科目號(hào)、學(xué)號(hào)、科目名稱、科目分?jǐn)?shù)等。選課基本信息:包括的數(shù)據(jù)項(xiàng)有:課程號(hào)、學(xué)號(hào)、修課審核人、成績(jī)審核人等。授課基本信息:包括的數(shù)據(jù)項(xiàng)有:課程號(hào)、教室編碼、教師編碼、授課時(shí)間、授課周次等。班級(jí)基本信息:包括的數(shù)據(jù)項(xiàng)有:班級(jí)代碼、班級(jí)名稱,班級(jí)簡(jiǎn)介等。數(shù)據(jù)流圖是從數(shù)據(jù)和對(duì)數(shù)據(jù)的加工處理的角度來(lái)描述系統(tǒng)的圖形。數(shù)據(jù)流圖的基本組成元素如下圖所示:數(shù)據(jù)存儲(chǔ) 圖3-1數(shù)據(jù)流圖的基本組成元素教學(xué)信息管理系統(tǒng)的基本數(shù)據(jù)流圖如下所示: 課程信息圖3-2

4、教學(xué)信息管理系統(tǒng)的基本數(shù)據(jù)流圖學(xué)生成績(jī)信息 學(xué)生學(xué)籍信息圖 3-3教學(xué)信息管理系統(tǒng)的基本數(shù)據(jù)流圖排課信息 圖3-4 教學(xué)信息管理系統(tǒng)的基本數(shù)據(jù)流圖1.2概念結(jié)構(gòu)設(shè)計(jì)概念結(jié)構(gòu)設(shè)計(jì)是把用戶的信息要求統(tǒng)一到一個(gè)整體邏輯結(jié)構(gòu)中,此結(jié)構(gòu)能夠表達(dá)用戶的要求,是一個(gè)獨(dú)立與任何DBMS軟件和硬件的概念模型。概念結(jié)構(gòu)設(shè)計(jì)是以需求分析所得到的系統(tǒng)數(shù)據(jù)字典和系統(tǒng)數(shù)據(jù)流圖為輸入,經(jīng)過(guò)加工處理后,輸出系統(tǒng)的實(shí)體、聯(lián)系模型(ERM。實(shí)體、聯(lián)系模型(ERM圖的基本組成元素如下圖所示: 圖3-5 實(shí)體、聯(lián)系模型(ERM圖的基本組成元素圖實(shí)體、聯(lián)系模型(ERM是概念設(shè)計(jì)階段描述概念結(jié)構(gòu)模型的只要設(shè)計(jì)工具,教學(xué)信息管理系統(tǒng)的E-

5、R圖包括以下內(nèi)容。 圖3-6 學(xué)生實(shí)體E-R圖 圖3-7 班級(jí)實(shí)體E-R圖 圖3-13成績(jī)實(shí)體E-R圖 圖3-14 各實(shí)體間的E-R圖1.3邏輯結(jié)構(gòu)設(shè)計(jì)邏輯結(jié)構(gòu)設(shè)計(jì)是將上一步所得到的概念模型轉(zhuǎn)換為SQL Server支持的數(shù)據(jù)模型,并對(duì)其進(jìn)行優(yōu)化。邏輯結(jié)構(gòu)設(shè)計(jì)是以概念結(jié)構(gòu)設(shè)計(jì)所得到系統(tǒng)的實(shí)體、聯(lián)系模型(ERM為輸入,經(jīng)過(guò)轉(zhuǎn)換處理后,輸出系統(tǒng)的關(guān)系數(shù)據(jù)結(jié)構(gòu)(表結(jié)構(gòu)。通過(guò)系統(tǒng)的實(shí)體、聯(lián)系模型(ERM進(jìn)行系統(tǒng)的關(guān)系數(shù)據(jù)結(jié)構(gòu)(表結(jié)構(gòu)轉(zhuǎn)換的總體原則如下:1E-R圖中的實(shí)體和有屬性的聯(lián)系轉(zhuǎn)換成關(guān)系2E-R圖中的屬性轉(zhuǎn)換成關(guān)系的屬性數(shù)據(jù)庫(kù)的表結(jié)構(gòu)是邏輯設(shè)計(jì)階段描述邏輯結(jié)構(gòu)模型的主要設(shè)計(jì)工具,教學(xué)信息管理系統(tǒng)

6、的數(shù)據(jù)庫(kù)表包括以下內(nèi)容: 表3-4 系信息表 表3-5班級(jí)信息表 表3-6課程信息表 表3-10 學(xué)生修課信息表 圖3-15 數(shù)據(jù)表之間的邏輯關(guān)系圖1.4數(shù)據(jù)庫(kù)物理設(shè)計(jì)物理結(jié)構(gòu)設(shè)計(jì)是為邏輯數(shù)據(jù)模型建立一個(gè)完整的能實(shí)現(xiàn)的數(shù)據(jù)庫(kù)結(jié)構(gòu),包括存儲(chǔ)結(jié)構(gòu)和存取方法。物理結(jié)構(gòu)設(shè)計(jì)是以邏輯結(jié)構(gòu)設(shè)計(jì)所得到系統(tǒng)的關(guān)系數(shù)據(jù)結(jié)構(gòu)(表結(jié)構(gòu)為輸入,經(jīng)過(guò)轉(zhuǎn)換處理后,輸出系統(tǒng)的數(shù)據(jù)庫(kù)物理結(jié)構(gòu)。1.5數(shù)據(jù)庫(kù)實(shí)施數(shù)據(jù)庫(kù)實(shí)施是根據(jù)應(yīng)用系統(tǒng)數(shù)據(jù)庫(kù)的關(guān)系結(jié)構(gòu)模型和物理結(jié)構(gòu)設(shè)計(jì)結(jié)果,形成基于SQL Server平臺(tái)應(yīng)用系統(tǒng)數(shù)據(jù)庫(kù)的腳本和數(shù)據(jù)庫(kù)設(shè)計(jì)報(bào)告,并進(jìn)行數(shù)據(jù)庫(kù)的具體構(gòu)建與管理。數(shù)據(jù)庫(kù)實(shí)施是以邏輯結(jié)構(gòu)設(shè)計(jì)和物理設(shè)計(jì)結(jié)構(gòu)所得到系統(tǒng)關(guān)系數(shù)

7、據(jù)結(jié)構(gòu)和系統(tǒng)數(shù)據(jù)庫(kù)物理結(jié)構(gòu)為輸入,經(jīng)過(guò)轉(zhuǎn)換處理后,輸出系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)腳本(包括數(shù)據(jù)庫(kù)定義、數(shù)據(jù)庫(kù)表定義和數(shù)據(jù)庫(kù)索引定義等。DROP DATABASE 教學(xué)管理信息系統(tǒng)GOCREATE DATABASE 教學(xué)管理信息系統(tǒng) ON (NAME = N教學(xué)管理信息系統(tǒng)_Data, FILENAME = NC:Program FilesMicrosoft SQL ServerMSSQLdata教學(xué)管理信息系統(tǒng)_Data.MDF , SIZE = 2, FILEGROWTH = 10% LOG ON (NAME = N教學(xué)管理信息系統(tǒng)_Log, FILENAME = NC:Program FilesMi

8、crosoft SQL ServerMSSQLdata教學(xué)管理信息系統(tǒng)_Log.LDF , SIZE = 1, FILEGROWTH = 10%COLLATE Chinese_PRC_CI_ASGOexec sp_dboption N教學(xué)管理信息系統(tǒng), Nautoclose, NtrueGOexec sp_dboption N教學(xué)管理信息系統(tǒng), Nbulkcopy, NfalseGOexec sp_dboption N教學(xué)管理信息系統(tǒng), Ntrunc. log, NtrueGOexec sp_dboption N教學(xué)管理信息系統(tǒng), Ntorn page detection, NtrueGOex

9、ec sp_dboption N教學(xué)管理信息系統(tǒng), Nread only, NfalseGOexec sp_dboption N教學(xué)管理信息系統(tǒng), Ndbo use, NfalseGOexec sp_dboption N教學(xué)管理信息系統(tǒng), Nsingle, NfalseGOexec sp_dboption N教學(xué)管理信息系統(tǒng), Nautoshrink, NtrueGOexec sp_dboption N教學(xué)管理信息系統(tǒng), NANSI null default, NfalseGOexec sp_dboption N教學(xué)管理信息系統(tǒng), Nrecursive triggers, NfalseGOex

10、ec sp_dboption N教學(xué)管理信息系統(tǒng), NANSI nulls, NfalseGOexec sp_dboption N教學(xué)管理信息系統(tǒng), Nconcat null yields null, NfalseGOexec sp_dboption N教學(xué)管理信息系統(tǒng), Ncursor close on commit, NfalseGOexec sp_dboption N教學(xué)管理信息系統(tǒng), Ndefault to local cursor, NfalseGOexec sp_dboption N教學(xué)管理信息系統(tǒng), Nquoted identifier, NfalseGOexec sp_dbop

11、tion N教學(xué)管理信息系統(tǒng), NANSI warnings, NfalseGOexec sp_dboption N教學(xué)管理信息系統(tǒng), Nauto create statistics, NtrueGOexec sp_dboption N教學(xué)管理信息系統(tǒng), Nauto update statistics, NtrueGOuse 教學(xué)管理信息系統(tǒng)GOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.FK_student_class and OBJECTPROPERTY(id, NIsForeignKey = 1ALT

12、ER TABLE dbo.student DROP CONSTRAINT FK_student_classGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.FK_courseplan_classrooom and OBJECTPROPERTY(id, NIsForeignKey = 1ALTER TABLE dbo.courseplan DROP CONSTRAINT FK_courseplan_classrooomGOif exists (select * from dbo.sysobjects where

13、 id = object_id(Ndbo.FK_courseplan_course and OBJECTPROPERTY(id, NIsForeignKey = 1ALTER TABLE dbo.courseplan DROP CONSTRAINT FK_courseplan_courseGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.FK_xxxx_course and OBJECTPROPERTY(id, NIsForeignKey = 1ALTER TABLE dbo.xxxx DROP CONSTR

14、AINT FK_xxxx_courseGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.FK_speciality_department and OBJECTPROPERTY(id, NIsForeignKey = 1ALTER TABLE dbo.speciality DROP CONSTRAINT FK_speciality_departmentGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.FK_class_spec

15、iality and OBJECTPROPERTY(id, NIsForeignKey = 1ALTER TABLE dbo.class DROP CONSTRAINT FK_class_specialityGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.FK_exam_grade_student and OBJECTPROPERTY(id, NIsForeignKey = 1ALTER TABLE dbo.exam_grade DROP CONSTRAINT FK_exam_grade_studentGO

16、if exists (select * from dbo.sysobjects where id = object_id(Ndbo.FK_xxxx_student and OBJECTPROPERTY(id, NIsForeignKey = 1ALTER TABLE dbo.xxxx DROP CONSTRAINT FK_xxxx_studentGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.FK_courseplan_teacher and OBJECTPROPERTY(id, NIsForeignKey

17、 = 1ALTER TABLE dbo.courseplan DROP CONSTRAINT FK_courseplan_teacherGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.view_examgrade and OBJECTPROPERTY(id, NIsView = 1drop view dbo.view_examgradeGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.class and OBJECTPRO

18、PERTY(id, NIsUserTable = 1drop table dbo.classGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.classrooom and OBJECTPROPERTY(id, NIsUserTable = 1drop table dbo.classrooomGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.course and OBJECTPROPERTY(id, NIsUserTable

19、= 1drop table dbo.courseGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.courseplan and OBJECTPROPERTY(id, NIsUserTable = 1drop table dbo.courseplanGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.department and OBJECTPROPERTY(id, NIsUserTable = 1drop table dbo.

20、departmentGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.exam_grade and OBJECTPROPERTY(id, NIsUserTable = 1drop table dbo.exam_gradeGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.speciality and OBJECTPROPERTY(id, NIsUserTable = 1drop table dbo.specialityGOif

21、 exists (select * from dbo.sysobjects where id = object_id(Ndbo.student and OBJECTPROPERTY(id, NIsUserTable = 1drop table dbo.studentGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.teacher and OBJECTPROPERTY(id, NIsUserTable = 1drop table dbo.teacherGOif exists (select * from dbo

22、.sysobjects where id = object_id(Ndbo.xxxx and OBJECTPROPERTY(id, NIsUserTable = 1drop table dbo.xxxxGOCREATE TABLE dbo.class (code varchar (20 COLLATE Chinese_PRC_CI_AS NOT NULL ,name varchar (30 COLLATE Chinese_PRC_CI_AS NOT NULL ,classshort varchar (30 COLLATE Chinese_PRC_CI_AS NULL ,intime datet

23、ime NULL ,speci_code varchar (20 COLLATE Chinese_PRC_CI_AS NULLON PRIMARYGOCREATE TABLE dbo.classrooom (code varchar (20 COLLATE Chinese_PRC_CI_AS NOT NULL ,capacity numeric(18, 0 NULL ,type varchar (20 COLLATE Chinese_PRC_CI_AS NULLON PRIMARYGOCREATE TABLE dbo.course (code varchar (20 COLLATE Chine

24、se_PRC_CI_AS NOT NULL ,name varchar (20 COLLATE Chinese_PRC_CI_AS NOT NULL ,period varchar (20 COLLATE Chinese_PRC_CI_AS NULL ,number numeric(18, 0 NULL ,credithour numeric(18, 0 NULLON PRIMARYGOCREATE TABLE dbo.courseplan (teach_code varchar (20 COLLATE Chinese_PRC_CI_AS NOT NULL , couse_code varch

25、ar (20 COLLATE Chinese_PRC_CI_AS NOT NULL , room_code varchar (20 COLLATE Chinese_PRC_CI_AS NOT NULL , tabletime varchar (10 COLLATE Chinese_PRC_CI_AS NULL ,week varchar (10 COLLATE Chinese_PRC_CI_AS NULLON PRIMARYGOCREATE TABLE dbo.department (code varchar (20 COLLATE Chinese_PRC_CI_AS NOT NULL ,na

26、me varchar (20 COLLATE Chinese_PRC_CI_AS NOT NULL ,address varchar (30 COLLATE Chinese_PRC_CI_AS NULL ,telephone varchar (12 COLLATE Chinese_PRC_CI_AS NULLON PRIMARYGOCREATE TABLE dbo.exam_grade (code varchar (20 COLLATE Chinese_PRC_CI_AS NOT NULL ,kmname varchar (20 COLLATE Chinese_PRC_CI_AS NOT NU

27、LL , stude_code varchar (20 COLLATE Chinese_PRC_CI_AS NOT NULL , kmgrade datetime NULL ,grade numeric(18, 0 NULLON PRIMARYGOCREATE TABLE dbo.speciality (code varchar (20 COLLATE Chinese_PRC_CI_AS NOT NULL ,name varchar (20 COLLATE Chinese_PRC_CI_AS NOT NULL ,spechar varchar (50 COLLATE Chinese_PRC_C

28、I_AS NULL ,specshort varchar (50 COLLATE Chinese_PRC_CI_AS NULL ,degree varchar (20 COLLATE Chinese_PRC_CI_AS NULL ,depar_code varchar (20 COLLATE Chinese_PRC_CI_AS NOT NULL ON PRIMARYGOCREATE TABLE dbo.student (code varchar (20 COLLATE Chinese_PRC_CI_AS NOT NULL ,name varchar (10 COLLATE Chinese_PR

29、C_CI_AS NOT NULL ,sex varchar (2 COLLATE Chinese_PRC_CI_AS NULL ,title varchar (16 COLLATE Chinese_PRC_CI_AS NULL ,face varchar (10 COLLATE Chinese_PRC_CI_AS NULL ,brithday datetime NULL ,nativeplace varchar (12 COLLATE Chinese_PRC_CI_AS NULL ,address varchar (30 COLLATE Chinese_PRC_CI_AS NULL ,clas

30、s_code varchar (20 COLLATE Chinese_PRC_CI_AS NOT NULL ON PRIMARYGOCREATE TABLE dbo.teacher (code varchar (20 COLLATE Chinese_PRC_CI_AS NOT NULL ,name varchar (10 COLLATE Chinese_PRC_CI_AS NOT NULL ,sex varchar (2 COLLATE Chinese_PRC_CI_AS NULL ,specialiy varchar (16 COLLATE Chinese_PRC_CI_AS NOT NUL

31、L , title varchar (16 COLLATE Chinese_PRC_CI_AS NOT NULL ,birthday datetime NULL ,nativeplace varchar (12 COLLATE Chinese_PRC_CI_AS NULL ,address varchar (30 COLLATE Chinese_PRC_CI_AS NULLON PRIMARYGOCREATE TABLE dbo.xxxx (cours_code varchar (20 COLLATE Chinese_PRC_CI_AS NOT NULL , stude_code varcha

32、r (20 COLLATE Chinese_PRC_CI_AS NOT NULL , cours_audit varchar (10 COLLATE Chinese_PRC_CI_AS NULL ,grade_audit varchar (10 COLLATE Chinese_PRC_CI_AS NULLON PRIMARYGOALTER TABLE dbo.class WITH NOCHECK ADDCONSTRAINT PK_class PRIMARY KEY CLUSTERED(codeON PRIMARYGOALTER TABLE dbo.classrooom WITH NOCHECK

33、 ADD CONSTRAINT PK_classrooom PRIMARY KEY CLUSTERED (codeON PRIMARYGOALTER TABLE dbo.course WITH NOCHECK ADDCONSTRAINT PK_course PRIMARY KEY CLUSTERED(codeON PRIMARYGOALTER TABLE dbo.department WITH NOCHECK ADD CONSTRAINT PK_xi PRIMARY KEY CLUSTERED(codeON PRIMARYGOALTER TABLE dbo.exam_grade WITH NO

34、CHECK ADD CONSTRAINT PK_exam_grade PRIMARY KEY CLUSTERED (codeON PRIMARYGOALTER TABLE dbo.speciality WITH NOCHECK ADDCONSTRAINT PK_speciality PRIMARY KEY CLUSTERED(codeON PRIMARYGOALTER TABLE dbo.student WITH NOCHECK ADD CONSTRAINT PK_student PRIMARY KEY CLUSTERED (codeON PRIMARYGOALTER TABLE dbo.te

35、acher WITH NOCHECK ADD CONSTRAINT DF_teacher_sex DEFAULT (=男 FOR sex, CONSTRAINT PK_teacher PRIMARY KEY CLUSTERED (codeON PRIMARYGOALTER TABLE dbo.class ADDCONSTRAINT FK_class_speciality FOREIGN KEY(speci_codeREFERENCES dbo.speciality (codeGOALTER TABLE dbo.courseplan ADDCONSTRAINT FK_courseplan_cla

36、ssrooom FOREIGN KEY (room_codeREFERENCES dbo.classrooom (code,CONSTRAINT FK_courseplan_course FOREIGN KEY(couse_codeREFERENCES dbo.course (code,CONSTRAINT FK_courseplan_teacher FOREIGN KEY(teach_codeREFERENCES dbo.teacher (codeGOALTER TABLE dbo.exam_grade ADDCONSTRAINT FK_exam_grade_student FOREIGN

37、KEY (stude_codeREFERENCES dbo.student (codeGOALTER TABLE dbo.speciality ADDCONSTRAINT FK_speciality_department FOREIGN KEY (depar_codeREFERENCES dbo.department (codeGOALTER TABLE dbo.student ADDCONSTRAINT FK_student_class FOREIGN KEY(class_codeREFERENCES dbo.class (codeGOALTER TABLE dbo.xxxx ADDCONS

38、TRAINT FK_xxxx_course FOREIGN KEY(cours_codeREFERENCES dbo.course (code,CONSTRAINT FK_xxxx_student FOREIGN KEY(stude_codeREFERENCES dbo.student (codeGOSET QUOTED_IDENTIFIER ONGOSET ANSI_NULLS ONGOCREATE VIEW dbo.view_examgradeASFROM dbo.department INNER JOINGOSET QUOTED_IDENTIFIER OFFGOSET ANSI_NULL

39、S ONGO第二章教學(xué)管理信息系統(tǒng)數(shù)據(jù)庫(kù)實(shí)施1.項(xiàng)目實(shí)踐1.1數(shù)據(jù)庫(kù)的創(chuàng)建數(shù)據(jù)庫(kù)和數(shù)據(jù)庫(kù)文件的命名應(yīng)符合數(shù)據(jù)庫(kù)對(duì)象命名基本規(guī)范,CREA TE DATABASE命令語(yǔ)句的編寫(xiě)應(yīng)符合Transact-SQL編程基本規(guī)范。1.2表對(duì)象的創(chuàng)建參照數(shù)據(jù)庫(kù)表定義語(yǔ)句,使用Transact-SQL語(yǔ)言在查詢分析器中進(jìn)行教學(xué)管理信息系統(tǒng)數(shù)據(jù)庫(kù)中教師信息表、專業(yè)信息表、班級(jí)信息表、學(xué)生信息表、課程信息表、教師信息表、授課安排信息表、成績(jī)信息表、學(xué)生選修信息表、系信息表的創(chuàng)建。表、字段、主鍵和外鍵的命名應(yīng)符合數(shù)據(jù)庫(kù)對(duì)象命名基本規(guī)范,CREATE TABLE明令語(yǔ)句的編寫(xiě)應(yīng)符合Transact-SQL編程基本規(guī)范

40、。1.3視圖對(duì)象的創(chuàng)建使用Transact-SQL語(yǔ)言在查詢分析器中創(chuàng)建view_examgrade視圖。view_examgrade視圖對(duì)象的定義是檢索學(xué)生號(hào)及學(xué)生所屬的系和專業(yè)的名稱及代碼。FROM dbo.department INNER JOIN 1.4 索引對(duì)象的創(chuàng)建索引是一種特殊類型的數(shù)據(jù)庫(kù)對(duì)象,它保存著數(shù)據(jù)表中一列或及列組合的排結(jié)構(gòu),為數(shù)據(jù)表增加索引,可以大大提高數(shù)據(jù)的檢索效率。參照數(shù)據(jù)庫(kù)索引定義語(yǔ)句,使用Transact SQL 語(yǔ)言在查詢分析器中進(jìn)行教學(xué)管理信息系統(tǒng)數(shù)據(jù)庫(kù)索引對(duì)象的創(chuàng)建。索引的命名應(yīng)符合數(shù)據(jù)庫(kù)對(duì)象命名基本規(guī)范,CREATE INDEX命令語(yǔ)句的的編寫(xiě)應(yīng)符合Transact SQL編程基本規(guī)