数据库分析和总结.docxVIP

1 建立数据库库 create database 学生管理系统 on primary ( name=guanli_data, filename=D:\管理库 guanli_data.mdf, size=10mb, maxsize=unlimited, filegrowth=15% ) log on( name=guanli_data1, filename=D:\管理库 guanli_data.ldf, size=10mb, maxsize=unlimited, filegrowth=15% ) 2，建立班级信息表 GO use 学生管理系统 go create table ClassInfo (Classid varchar(10) Primary key, Specialtyi varchar(30) not null, Studentnumber varchar(4) not null, ClassName int null, remark varchar(100) ) 3，学生信息表create table StudentInfo ( Sno varchar(10)Primary key, Sname Varchar(20) not null, Sex char(2) not null, Birthday Datetime null, Classid varchar(20) not null, Tel varchar(100) null, Address varchar(100) null ) 4，课程信息表create table CourseInfo (Kcid varchar(10) Primary key, Kcname varchar(50) Not null, Periodexpriment int not null, Periodteaching int not null, credit numeric not null, coursetype Varchar(6)not null ) 5,建立成绩表 create table StuGrade ( Sno varchar(10) Primary key , Cno varchar(10) not null, Gradepeacetime numeric Null, Gradeexpriment numeric Null, Gradelast numeric Null, Grade numeric Null ) 6,教师表 create table TeacherInfo ( Teaid varchar(10) Primary key, Teaname varchar(20) Not null, Teasex Char(2) Not null, Teloffice varchar(20) Not null, Address varchar(100) null, TeaBirthday Datetime null ) 专业表（SpecialtyInfo） create table SpecialtyInfo (Specialtyid varchar(4) Primary key, Specialtymc varchar(50) Not null ) 用户表 UserInfo create table UserInfo( Userid varchar(10) Primary key, Userpwd varchar(10) Not null , Userlevel varchar(10) Not null ) insert into UserInfo(Userid,Userpwd ,Userlevel ) values( 康志龙,1,管理员)