这是本人应用VB在SQLsever2000环境下开发的新生信息管理系统

USE 学生信息管理系统

Create table Code_Depart
( code int primary key,
  name Varchar(50)not NUll,
)
CREATE TABLE STUDENT
(studentNo char(6) PRIMARY KEY,
 name VarChar(20) Not Null,
  sex char(2),  
 departNO int,
 classNO int,
birthday datetime,
native Varchar(50),
phone char(20),
address varchar(100),
zipCode char(8),
email varchar(50),
photo Image,
memo varchar(1000)
Constraint departNoFkey3 foreign Key(departNo)
references Code_Depart(code)
)
create table Code_Change
(code char(1) primary key,
 description varchar(50),
)
create table Code_Reward
(code char(1) primary key,
 description varchar(50),
)
create table Code_Punish
(code char(1) primary key,
 description varchar(50),
)
create table CHANGE 
(id int Primary key,
 studentNo char(6) Not NULl,
 changeNo char(1),
  recordTime Datetime ,
 memo Varchar(1000),
 Constraint studentNoFkey3 Foreign Key(studentNO)
references Student(studentNO),
Constraint changeNoFkey Foreign key(changeNo)
references Code_Change(code)
)
create table REWARD
(id int primary key,
 studentNo char(6) not null,
 levelNo char(1),
recordtime datetime,
memo varchar(1000),
Constraint studentNoFkey Foreign Key(studentNo)
references student(studentNo),
 Constraint levelNoFkey Foreign Key(levelNo)
 references Code_REWARD(code)
) 
create table Punishment
( id int Primary key,
  studentNo char(6) not null,
  levelNo char(1),
  enable char(2),
  recordTime datetime,
  memo VarChar(1000),
 Constraint studentNoFkey2 Foreign Key(studentNo)
references student(studentNo),
 Constraint levelNoFkey2 Foreign Key(levelNo)
 references Code_Punish(code)
)

Create table Code_Class
(code int primary key,
 className varchar(50) not null,
 departNo int Not Null,
 monitor char(6)
constraint departNoFkey4 Foreign key(departNo)
references code_Depart(code)
 )