【数据库原理课程设计】学校教学管理系统.doc

2010GIS 0940310232010-11-30 1 . 11. 11. 1. 11. 2. 11. 3. 11. 4. 12. 22. 1. 23. 2. 24. 3. 23. 25. 1. 25.1. 1. 23.1.2. 23.1.3. 33.1.4. 33.1.5. 33.1.6. 36. 2. 36.1. 1. 36.2. 2. 36.3. 3. 47. 3. 48. 4. 49. 5. 44. 5 24.1. 510. 2. 511. 3. 64.3.1E-R . 64.3.2. 74.3.3 SQL Server 2000 . 74.3.45. 74.3.5. 95. 912. 1. 913. 2. 105.2.1. 105.2.2. 105.2.3. 105.2.4. 105.2.5. 115.2.6. 116. 117. 297.1. 297.2. 297.3. 2911 1.1 1.2 MIS1.3 IEEE(1997)(1)(Capability)(2)(3)(1)(2) 1.4 UDC681.3GB/T8566-1995GB 856788GB/T11457-1995IEEE(1997) 14. 2 2.1 2.2 2.3 WindowsInternet Explorerpc 3 3.1 3.1.1 3.1.2 33.1.3 3.1.4 3.1.5 3.1.6 112 3.2 3.2.1 3.2.2 435 3.2.3 3.3 3.4 , 3.5 54 4.1 WebPC Windows984.2 Windows2000SQL SEVER 2000.NET Framework PC Windows98IE5.0 E-R 1,n1,n1,n1,n1,n1,nEntity_StudentAttribute_Student_IDAttribute_Student_NameAttribute_Student_AcademyLIVA50VA50Attribute_Student_IDEntity_CourseAttribute_Course_IDAttribute_PeriodAttribute_Credit_HourLILILIAttribute_Course_IDEntity_TeacherAttribute_Teacher_IDAttribute_Teacher_NameAttribute_Teacher_AcademyLIVA50VA50Attribute_Teacher_IDAssociation_Teach_ClassAttribute_Class_TimeAttribute_Class_PlaceVA50VA50Association_ExamAttribute_MarkF74.3.2 RStudent ( Student ID, Student Name, Student Academy)RTeacher( Teacher ID, Teacher Name, Teacher Academy)RCourse ( Course ID, Period, Credit Hour)RTeach-Class ( Teacher ID, Course ID, Student ID, Class Time, Class Place)RExam ( Teacher ID, Course ID, Student ID, Mark) 4.3.3 SQL Server 2000 FK_ASSOCIAT_ASSOCIATI_ENTITY_SFK_ASSOCIAT_ASSOCIATI_ENTITY_SFK_ASSOCIAT_ASSOCIATI_ENTITY_CFK_ASSOCIAT_ASSOCIATI_ENTITY_TFK_ASSOCIAT_ASSOCIATI_ENTITY_TFK_ASSOCIAT_ASSOCIATI_ENTITY_CEntity_StudentAttribute_Student_IDAttribute_Student_NameAttribute_Student_Academybigintvarchar(50)varchar(50)Entity_CourseAttribute_Course_IDAttribute_PeriodAttribute_Credit_HourbigintbigintbigintEntity_TeacherAttribute_Teacher_IDAttribute_Teacher_NameAttribute_Teacher_Academybigintvarchar(50)varchar(50)Association_Teach_ClassAttribute_Teacher_IDAttribute_Course_IDAttribute_Student_IDAttribute_Class_TimeAttribute_Class_Placebigintbigintbigintvarchar(50)varchar(50)Association_ExamAttribute_Teacher_IDAttribute_Course_IDAttribute_Student_IDAttribute_Markbigintbigintbigintfloat 4.3.45 8 94.3.5 5 5.1 TMSTMS 10 5.2 5.2.1 5.2.2 5.2.3 5.2.4 11 5.2.5 5.2.6 6 SQL /* Object: Database TMS Script Date: 2003-1-15 5:39:06 */ IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = NTMS)DROP DATABASE TMSGOCREATE DATABASE TMS ON (NAME = NTMS_Data, FILENAME =Nd:MSQLDATAMSSQLdataTMS_Data.MDF , SIZE = 1, FILEGROWTH = 10%) LOG ON(NAME = NTMS_Log, FILENAME = Nd:MSQLDATAMSSQLdataTMS_Log.LDF , SIZE =1, FILEGROWTH = 10%)COLLATE Chinese_PRC_CI_ASGOexec sp_dboption NTMS, Nautoclose, NfalseGOexec sp_dboption NTMS, Nbulkcopy, NfalseGOexec sp_dboption NTMS, Ntrunc. log, NfalseGOexec sp_dboption NTMS, Ntorn page detection, Ntrue 12GOexec sp_dboption NTMS, Nread only, NfalseGOexec sp_dboption NTMS, Ndbo use, NfalseGOexec sp_dboption NTMS, Nsingle, NfalseGOexec sp_dboption NTMS, Nautoshrink, NfalseGOexec sp_dboption NTMS, NANSI null default, NfalseGOexec sp_dboption NTMS, Nrecursive triggers, NfalseGOexec sp_dboption NTMS, NANSI nulls, NfalseGOexec sp_dboption NTMS, Nconcat null yields null, NfalseGOexec sp_dboption NTMS, Ncursor close on commit, NfalseGOexec sp_dboption NTMS, Ndefault to local cursor, NfalseGOexec sp_dboption NTMS, Nquoted identifier, NfalseGOexec sp_dboption NTMS, NANSI warnings, NfalseGOexec sp_dboption NTMS, Nauto create statistics, NtrueGOexec sp_dboption NTMS, Nauto update statistics, NtrueGO13use TMSGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.FK_Exam_Course) andOBJECTPROPERTY(id, NIsForeignKey) = 1)ALTER TABLE dbo.Exam DROP CONSTRAINT FK_Exam_CourseGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.FK_Teach_Class_Course)and OBJECTPROPERTY(id, NIsForeignKey) = 1)ALTER TABLE dbo.Teach_Class DROP CONSTRAINT FK_Teach_Class_CourseGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.FK_Exam_Student) andOBJECTPROPERTY(id, NIsForeignKey) = 1)ALTER TABLE dbo.Exam DROP CONSTRAINT FK_Exam_StudentGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.FK_Teach_Class_Student)and OBJECTPROPERTY(id, NIsForeignKey) = 1)ALTER TABLE dbo.Teach_Class DROP CONSTRAINT FK_Teach_Class_StudentGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.FK_Exam_Teacher) andOBJECTPROPERTY(id, NIsForeignKey) = 1)ALTER TABLE dbo.Exam DROP CONSTRAINT FK_Exam_TeacherGOif exists (select * from dbo.sysobjects where id = object_id(Ndbo.FK_Teach_Class_Teacher)and OBJECTPROPERTY(id, NIsForeignKey) = 1)ALTER TABLE dbo.Teach_Class DROP CONSTRAINT FK_Teach_Class_TeacherGO/* Object: View dbo.VIEW_Appoint_Course Script Date: 2003-1-15 5:39:08 */if exists (select * from dbo.sysobjects where id = object_id(Ndbo.VIEW_Appoint_Course)and OBJECTPROPERTY(id, NIsView) = 1)drop view dbo.VIEW_Appoint_CourseGO/* Object: View dbo.VIEW_Choose_Course Script Date: 2003-1-15 5:39:08 */if exists (select * from dbo