【正文】 Chinese_PRC_CI_AS NOT NULL, [Password] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL, [FullName] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL, [DepartmentNO] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NULL, [EMail] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [Phone] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL, [Mobile] [nvarchar](15) COLLATE Chinese_PRC_CI_AS NULL, [Title] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NULL, [Role] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_Teacher] PRIMARY KEY CLUSTERED 班級表： CREATE TABLE [dbo].[Class]( [ClassNO] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [ClassTutor] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_Class] PRIMARY KEY CLUSTERED 學(xué)生表： CREATE TABLE [dbo].[Student]( [UserName] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Password] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL, [FullName] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL, [ClassNO] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NULL, [EMail] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [Phone] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL, [Mobile] [nvarchar](15) COLLATE Chinese_PRC_CI_AS NULL, [TeacherNO] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED 學(xué)生志愿表： CREATE TABLE [dbo].[StudentAssignment]( [AssignmentID] [int] IDENTITY(1,1) NOT NULL, [StudentUserName] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [TeacherUserName] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL, Page15/17 [Year] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_StudentAssignment] PRIMARY KEY CLUSTERED 畢設(shè)課題表 CREATE TABLE [dbo].[Project]( [ProjectNO] [int] IDENTITY(1,1) NOT NULL, [ProjectName] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL, [ProjectType] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NULL, [Year] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NULL, [Content] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL, [Result] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL, [Demand] [nvarchar](5