【正文】 ginlang = 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。) 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。, sysadmin GO /****** Object: User dbo Script Date: 2021115 5:39:06 ******/ /****** Object: User teacher1 Script Date: 2021115 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: 2021115 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: 2021115 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: 2021115 5:39:07 ******/ 數(shù)據(jù)庫課程設(shè)計(jì) —— 教學(xué)管理系統(tǒng) 20if not exists (select * from where name = N39。 GO /****** Object: DatabaseRole Student Script Date: 2021115 5:39:07 ******/ if not exists (select * from where name = N39。 GO /****** Object: DatabaseRole Teacher Script Date: 2021115 5:39:07 ******/ if not exists (select * from where name = N39。 GO /****** Object: User ea1 Script Date: 2021115 5:39:07 ******/ exec sp_addrolemember N39。 GO /****** Object: User ea2 Script Date: 2021115 5:39:07 ******/ exec sp_addrolemember N39。 GO /****** Object: User student1 Script Date: 2021115 5:39:07 ******/ exec sp_addrolemember N39。 GO /****** Object: User student2 Script Date: 2021115 5:39:07 ******/ exec sp_addrolemember N39。 GO /****** Object: User teacher1 Script Date: 2021115 5:39:07 ******/ exec sp_addrolemember N39。 GO /****** Object: User teacher2 Script Date: 2021115 5:39:07 ******/ exec sp_addrolemember N39。 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è)計(jì) —— 教學(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è)計(jì) —— 教學(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 [Ind