【正文】 me = logindb) select logindb = N39。) select loginlang = language exec sp_addlogin N39。)BEGIN declare logindb nvarchar(132), loginlang nvarchar(132) select logindb = N39。 if logindb is null or not exists (select * from where name = logindb) select logindb = N39。) select loginlang = language exec sp_addlogin N39。)BEGIN declare logindb nvarchar(132), loginlang nvarchar(132) select logindb = N39。 if logindb is null or not exists (select * from where name = logindb) select logindb = N39。) select loginlang = language exec sp_addlogin N39。)BEGIN declare logindb nvarchar(132), loginlang nvarchar(132) select logindb = N39。 if logindb is null or not exists (select * from where name = logindb) select logindb = N39。) select loginlang = language exec sp_addlogin N39。, sysadminGO/****** Object: User dbo Script Date: 2003115 5:39:06 ******//****** Object: User teacher1 Script Date: 2003115 5:39:06 ******/if not exists (select * from where name = N39。, N39。 and uid 16382) EXEC sp_grantdbaccess N39。GO/****** Object: User student2 Script Date: 2003115 5:39:07 ******/if not exists (select * from where name = N39。, N39。 and uid 16382) EXEC sp_grantdbaccess N39。GO/****** Object: User ea1 Script Date: 2003115 5:39:07 ******/if not exists (select * from where name = N39。, N39。 and uid 16382) EXEC sp_grantdbaccess N39。GO/****** Object: DatabaseRole Educational Administrator Script Date: 2003115 5:39:07 ******/if not exists (select * from where name = N39。GO/****** Object: DatabaseRole Student Script Date: 2003115 5:39:07 ******/if not exists (select * from where name = N39。GO/****** Object: DatabaseRole Teacher Script Date: 2003115 5:39:07 ******/if not exists (select * from where name = N39。GO/****** Object: User ea1 Script Date: 2003115 5:39:07 ******/exec sp_addrolemember N39。GO/****** Object: User ea2 Script Date: 2003115 5:39:07 ******/exec sp_addrolemember N39。GO/****** Object: User student1 Script Date: 2003115 5:39:07 ******/exec sp_addrolemember N39。GO/****** Object: User student2 Script Date: 2003115 5:39:07 ******/exec sp_addrolemember N39。GO/****** Object: User teacher1 Script Date: 2003115 5:39:07 ******/exec sp_addrolemember N39。GO/****** Object: User teacher2 Script Date: 2003115 5:39:07 ******/exec sp_addrolemember N39。GO/****** Object: Table [dbo].[Course] Script Date: 2003115 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 , [Credit_Hour] [bigint] NOT NULL ) ON [PRIMARY]GO/****** Object: Table [dbo].[Exam] Script Date: 2003115 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: 2003115 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: 2003115 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: 2003115 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]GOALTER TABLE [dbo].[Course] WITH NOCHECK ADD CONSTRAINT [PK_Course] PRIMARY KEY CLUSTERED ( [Course_ID] ) ON [PRIMARY] GOALTER TABLE [dbo].[Student] WITH NOCHECK ADD CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED ( [Student_ID] ) ON [PRIMARY] GOALTER 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]GOALTER 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 GOALTER TABLE [dbo].[Teach_Class] ADD CONSTRAINT [FK_Teach_Class_Course] FOREIGN KEY ( [Course_ID] ) REFERENCES [dbo].[Course] ( [Co