数据库课程设计：题库管理系统

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_授课_学生]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[授课] DROP CONSTRAINT FK_授课_学生 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_授课_老师]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[授课] DROP CONSTRAINT FK_授课_老师 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_登记_试卷]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[登记] DROP CONSTRAINT FK_登记_试卷 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_选择_试卷]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[选择] DROP CONSTRAINT FK_选择_试卷 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_授课_课程]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[授课] DROP CONSTRAINT FK_授课_课程 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_选择_课程]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[选择] DROP CONSTRAINT FK_选择_课程 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_登记_题库]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[登记] DROP CONSTRAINT FK_登记_题库 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[course_test]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[course_test] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[student_course]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[student_course] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[shijuan_timu]') and OBJECTPROPERTY(id, N'IsView') = 1) drop view [dbo].[shijuan_timu] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[stu_cour_teacher]') and OBJECTPROPERTY(id, N'IsView') = 1) drop view [dbo].[stu_cour_teacher] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[学生]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[学生] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[授课]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[授课] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[登记]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[登记] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[老师]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[老师] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[试卷]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[试卷] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[课程]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[课程] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[选择]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[选择] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[题库]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[题库] GO CREATE TABLE [dbo].[学生] ( [学生号] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [学生姓名] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[授课] ( [课程号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [老师号] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [学生号] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [时间] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[登记] ( [试卷号] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [题号] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[老师] ( [老师号] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [姓名] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[试卷] ( [试卷号] [nvarchar] (20)�