create database School_MS
use School_MS
go
create table Student
(
Sno char(8) not null primary key,
Sname varchar(8) not null,
Sex char(2) check(Sex=‘男’ or Sex=‘女’),
Birthday Smalldatetime check(Birthday >='1990-01-01’and Birthday<= ‘2010-12-31’ ),
Dno char(6),
Home varchar(40),
Tel varchar(40),
Entime Smalldatetime,
Classno char(4) not null unique,
)
create table Course
(
Cno char(4) not null primary key,
Cname char(20) not null,
Experiment tinyint,
Lecture tinyint,
Semester tinyint,
Credit tinyint
)
create table Teacher
(
Tno char(8) not null primary key,
Tname char(8),
Sex char(2) check(Sex=‘男’ or Sex=‘女’),
Birthday smalldatetime,
Dno char(6),
Pno char(4),
Home varchar(40),
ZipCode char(20),
Tel varchar(40),
Email varchar(50)
)