【導(dǎo)讀】戶、項目管理人員和項目開發(fā)人員提供參考標(biāo)準(zhǔn)。項目背景該系統(tǒng)的最終用戶為學(xué)校的師生及教學(xué)管理人員。隨著高校的擴招，依靠原來。用戶解決問題或達到目標(biāo)所需的條件或權(quán)能。間進行有效的交流和溝通。目標(biāo)該系統(tǒng)是要將教學(xué)管理系統(tǒng)信息化，使操作方便，且效率高。系統(tǒng)環(huán)境假定為用戶擁有一臺pc機，能夠連上因特網(wǎng)（局域網(wǎng)）。約束為每個學(xué)院可有自己的特殊情況。選課子系統(tǒng)，成績管理子系統(tǒng)，系統(tǒng)管理子系統(tǒng)。成績管理子系統(tǒng)老師登記成績，學(xué)生查詢成績。精度系統(tǒng)精度主要包括系統(tǒng)信息流轉(zhuǎn)的正確與完整性。時間特性耍求系統(tǒng)的時間性能規(guī)定要求系統(tǒng)的大部分操作在用戶視覺延遲時間范圍之內(nèi)。密保護、身份鑒別。絡(luò)安全系統(tǒng)來提供保證,不屬于本系統(tǒng)數(shù)據(jù)安全性要求范圍內(nèi)。發(fā)生嚴(yán)重的系統(tǒng)故障如系統(tǒng)崩潰。對除此之外的系統(tǒng)故障應(yīng)是在簡單的配置和調(diào)。運行環(huán)境規(guī)定該運行環(huán)境的規(guī)定是保證本需求說明的功能得到實際真正體現(xiàn)的基礎(chǔ)。網(wǎng)絡(luò)環(huán)境要求包括：校園局域網(wǎng)。

　　

【正文】 select * from where name = N39。Teacher39。 and uid 16399) EXEC sp_addrole N39。Teacher39。 GO /****** Object: User ea1 Script Date: 2021115 5:39:07 ******/ exec sp_addrolemember N39。Educational Administrator39。, N39。ea139。 GO /****** Object: User ea2 Script Date: 2021115 5:39:07 ******/ exec sp_addrolemember N39。Educational Administrator39。, N39。ea239。 GO /****** Object: User student1 Script Date: 2021115 5:39:07 ******/ exec sp_addrolemember N39。Student39。, N39。student139。 GO /****** Object: User student2 Script Date: 2021115 5:39:07 ******/ exec sp_addrolemember N39。Student39。, N39。student239。 GO /****** Object: User teacher1 Script Date: 2021115 5:39:07 ******/ exec sp_addrolemember N39。Teacher39。, N39。teacher139。 GO /****** Object: User teacher2 Script Date: 2021115 5:39:07 ******/ exec sp_addrolemember N39。Teacher39。, N39。teacher239。 GO /****** Object: Table [dbo].[Course] Script Date: 2021115 5:39:09 ******/ CREATE TABLE [dbo].[Course] ( [Course_ID] [bigint] NOT NULL , [Course_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [Period] [bigint] NOT NULL , 數(shù)據(jù)庫課程設(shè)計 —— 教學(xué)管理系統(tǒng) 21 [Credit_Hour] [bigint] NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[Exam] Script Date: 2021115 5:39:09 ******/ CREATE TABLE [dbo].[Exam] ( [Teacher_ID] [bigint] NOT NULL , [Student_ID] [bigint] NOT NULL , [Course_ID] [bigint] NOT NULL , [Mark] [float] NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[Student] Script Date: 2021115 5:39:09 ******/ CREATE TABLE [dbo].[Student] ( [Student_ID] [bigint] NOT NULL , [Stuent_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [Academy] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[Teach_Class] Script Date: 2021115 5:39:10 ******/ CREATE TABLE [dbo].[Teach_Class] ( [Teacher_ID] [bigint] NOT NULL , [Course_ID] [bigint] NOT NULL , [Student_ID] [bigint] NOT NULL , [Teach_Time] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [Teach_Place] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[Teacher] Script Date: 2021115 5:39:10 ******/ CREATE TABLE [dbo].[Teacher] ( [Teacher_ID] [bigint] NOT NULL , [Teacher_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [Academy] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[Course] WITH NOCHECK ADD CONSTRAINT [PK_Course] PRIMARY KEY CLUSTERED ( [Course_ID] ) ON [PRIMARY] 數(shù)據(jù)庫課程設(shè)計 —— 教學(xué)管理系統(tǒng) 22GO ALTER TABLE [dbo].[Student] WITH NOCHECK ADD CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED ( [Student_ID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Teacher] WITH NOCHECK ADD CONSTRAINT [PK_Teacher] PRIMARY KEY CLUSTERED ( [Teacher_ID] ) ON [PRIMARY] GO CREATE UNIQUE CLUSTERED INDEX [Index_Exam] ON [dbo].[Exam]([Teacher_ID], [Student_ID], [Course_ID]) ON [PRIMARY] GO CREATE CLUSTERED INDEX [Index_Teacher_Class] ON [dbo].[Teach_Class]([Teacher_ID], [Course_ID], [Student_ID]) ON [PRIMARY] GO ALTER TABLE [dbo].[Exam] ADD CONSTRAINT [FK_Exam_Course] FOREIGN KEY ( [Course_ID] ) REFERENCES [dbo].[Course] ( [Course_ID] ) ON DELETE CASCADE ON UPDATE CASCADE , CONSTRAINT [FK_Exam_Student] FOREIGN KEY ( [Student_ID] ) REFERENCES [dbo].[Student] ( [Student_ID] ) ON DELETE CASCADE ON UPDATE CASCADE , CONSTRAINT [FK_Exam_Teacher] FOREIGN KEY ( [Teacher_ID] ) REFERENCES [dbo].[Teacher] ( [Teacher_ID] ) ON DELETE CASCADE ON UPDATE CASCADE GO 數(shù)據(jù)庫課程設(shè)計 — — 教學(xué)管理系統(tǒng) 23 ALTER TABLE [dbo].[Teach_Class] ADD CONSTRAINT [FK_Teach_Class_Course] FOREIGN KEY ( [Course_ID] ) REFERENCES [dbo].[Course] ( [Course_ID] ) ON DELETE CASCADE ON UPDATE CASCADE , CONSTRAINT [FK_Teach_Class_Student] FOREIGN KEY ( [Student_ID] ) REFERENCES [dbo].[Student] ( [Student_ID] ) ON DELETE CASCADE ON UPDATE CASCADE , CONSTRAINT [FK_Teach_Class_Teacher] FOREIGN KEY ( [Teacher_ID] ) REFERENCES [dbo].[Teacher] ( [Teacher_ID] ) ON DELETE CASCADE ON UPDATE CASCADE GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO /****** Object: View Script Date: 2021115 5:39:10 ******/ CREATE VIEW AS SELECT Student_ID AS 學(xué)號 , Stuent_Name AS 姓名 , Academy AS 學(xué)院 FROM GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO GRANT SELECT ON [dbo].[VIEWS_Student_Info] TO [Teacher] GO GRANT SELECT ON [dbo].[VIEWS_Student_Info] TO [Student] 數(shù)據(jù)庫課程設(shè)計 —— 教學(xué)管理系統(tǒng) 24GO GRANT SELECT , UPDATE , INSERT , DELETE ON [dbo].[VIEWS_Student_Info] TO [ea1] GO GRANT SELECT , UPDATE , INSERT , DELETE ON [dbo].[VIEWS_Student_Info] TO [ea2] GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO /****** Object: View Script Date: 2021115 5:39:10 ******/ CREATE VIEW AS SELECT Teacher_ID AS 教師號 , Teacher_Name AS 姓名 , Academy AS 所屬學(xué)院 FROM GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO G