数据库：常用数据库的创建

CREATE DATABASE teaching
 ON  PRIMARY 
( NAME = N'teaching', FILENAME = N'D:\SQL SERVER 上机数据库\teaching\teaching.mdf' , SIZE = 13312KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'teaching_log', FILENAME = N'D:\SQL SERVER 上机数据库\teaching\teaching_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO

USE teaching


CREATE TABLE [dbo].[class](
	[classno] [nchar](7) NOT NULL,
	[classname] [nchar](12) NULL,
	[department] [nchar](12) NULL,
	[monitor] [nchar](8) NULL,
 CONSTRAINT [PK_class] PRIMARY KEY CLUSTERED 
(
	[classno] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


CREATE TABLE [dbo].[course](
	[courseno] [nchar](6) NOT NULL,
	[cname] [nchar](20) NULL,
	[type] [nchar](8) NULL,
	[period] [tinyint] NULL,
	[credit] [tinyint] NULL,
	[term] [tinyint] NULL,
 CONSTRAINT [PK_course] PRIMARY KEY CLUSTERED 
(
	[courseno] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


CREATE TABLE [dbo].[score](
	[studentno] [nchar](11) NOT NULL,
	[courseno] [nchar](6) NOT NULL,
	[daily] [numeric](6, 2) NULL,
	[final] [numeric](6, 2) NULL,
	[zongping] [char](10) NULL,
 CONSTRAINT [PK_score] PRIMARY KEY CLUSTERED 
(
	[studentno] ASC,
	[courseno] ASC
) 
) 


CREATE TABLE [dbo].[student](
	[studentno] [nchar](11) NOT NULL,
	[sname] [nchar](8) NULL,
	[sex] [nchar](1) NULL,
	[birthdate] [date] NULL,
	[classno] [nchar](7) NULL,
	[point] [smallint] NULL,
	[phone] [nchar](12) NULL,
	[Email] [nvarchar](20) NULL,
 CONSTRAINT [PK_student] PRIMARY KEY CLUSTERED 
(
	[studentno] ASC
)) 


CREATE TABLE [dbo].[teach_class](
	[teacherno] [nchar](6) NOT NULL,
	[classno] [nchar](7) NOT NULL,
	[courseno] [nchar](6) NOT NULL,
 CONSTRAINT [PK_teach_class] PRIMARY KEY CLUSTERED 
(
	[teacherno] ASC,
	[classno] ASC,
	[courseno] ASC
)) 


CREATE TABLE [dbo].[teacher](
	[teacherno] [nchar](6) NOT NULL,
	[tname] [nchar](8) NULL,
	[major] [nchar](10) NULL,
	[prof] [nchar](10) NULL,
	[department] [nchar](12) NULL,
 CONSTRAINT [PK_teacher] PRIMARY KEY CLUSTERED 
(
	[teacherno] ASC
))  

GO