学生成绩管理系统——建表

学生成绩管理系统-建表
/*--案例：使用SQL语句创建Student表--*/
CREATE TABLE [dbo].[Student](
[StudentNo] [int] NOT NULL,
[LoginPwd] [nvarchar](50) NOT NULL,
[StudentName] [nvarchar](50) NOT NULL,
[Sex] bit NOT NULL,
[GradeId] [int] NOT NULL,
[Phone] [nvarchar](50) NULL,
[Address] [nvarchar](255) NULL,
[BornDate] [datetime] NOT NULL,
[Email] [nvarchar](50) NULL,
[IdentityCard] [varchar](18) NOT NULL
)
/*--查询得到Student表的信息--*/
USE MySchool
GO
SELECT * FROM sysobjects
/*--案例：使用SQL语句删除表Student--*/
IF EXISTS(SELECT * FROM sysobjects WHERE name='Student') DROP TABLE Student
/*--案例：使用SQL语句创建Subject表--*/
IF EXISTS(SELECT * FROM sysobjects WHERE name='Subject') DROP TABLE Subject
CREATE TABLE [dbo].[Subject](
[SubjectNo] [int] IDENTITY(1,1) NOT NULL,
[SubjectName] [nchar](50) NOT NULL,
[ClassHour] [int] NOT NULL,
[GradeId] [int] NOT NULL
)
/*--案例：使用SQL语句创建Result表--*/
IF EXISTS(SELECT * FROM sysobjects WHERE name='Result') DROP TABLE Result
CREATE TABLE [dbo].[Result](
[StudentNo] [int] NOT NULL,
[SubjectNo] [int] NOT NULL,
[StudentResult] [int] NOT NULL,
[ExamDate] [datetime] NOT NULL
)
/*--案例：使用SQL脚本创建Student表--*/
IF EXISTS(SELECT * FROM sysobjects WHERE name='Student')
DROP TABLE Student
CREATE TABLE [dbo].[Student](
[StudentNo] [int] NOT NULL,
[LoginPwd] [nvarchar](50) NOT NULL,
[StudentName] [nvarchar](50) NOT NULL,
[Sex] [bit] NOT NULL,
[GradeId] [int] NOT NULL,
[Phone] [varchar](50) NULL,
[Address] [nvarchar](255) NULL,
[BornDate] [datetime] NOT NULL,
[Email] [varchar](50) NULL,
[IdentityCard] [varchar](18) NOT NULL,
)
/*--案例：使用SQL脚本创建Grade表--*/
IF EXISTS(SELECT * FROM sysobjects WHERE name='Grade')
DROP TABLE Grade
CREATE TABLE [dbo].[Grade](
[GradeId] [int] IDENTITY(1,1) NOT NULL,
[GradeName] [nvarchar](50) NOT NULL
)
----资料来源北大青鸟中关村官网
北大青鸟中关村软件园官网
北大青鸟中关村学士后本部官网。