文档介绍:create database Student_acheieve_system;
use Student_acheieve_system;
---------------------学生表------------------------------------
create table Tbl_StudentInfo
(
Stuno Char(5) not null ,
Stuname Varchar(20) not null,
Stubirth Date,
Stusex Enum('0','1') default'0',
StuAddr Varchar(200),
StuTel Varchar(11),
PRIMARY KEY (Stuno)
);
insert into Tbl_StudentInfo(Stuno,Stuname,Stubirth,Stusex,StuAddr,StuTel) value('05001','张三','1988-12-12','0','江苏南京',12345);
insert into Tbl_StudentInfo(Stuno,Stuname,Stubirth,Stusex,StuAddr,StuTel) value('05002','李四','1987-06-05','1','上海',12346);
insert into Tbl_StudentInfo(Stuno,Stuname,Stubirth,Stusex,StuAddr,StuTel) value('05003','王五','1987-12-01','0','北京',12347);
insert into Tbl_StudentInfo(Stuno,Stuname,Stubirth,Stusex,StuAddr,StuTel) value('05004','赵六','1986-02-23','1','广东深圳',12348);
insert into Tbl_StudentInfo(Stuno,Stuname,Stubirth,Stusex,StuAddr,StuTel) value('05005','张三','1988-04-01','0','重庆',12349);
insert into Tbl_StudentInfo(Stuno,Stuname,Stubirth,Stusex,StuAddr,StuTel) value('05006','孙七','1988-07-03','1','湖北武汉','');
--------------------------课程表-------------------------------
create table Tbl_ClassInfo
(
classno Char(3) not null,
Classname Varchar(10) not null,
primary key(classno)
);
insert into Tbl_ClassInfo(classno,Classname) value('001','计算机');
insert into Tbl_ClassInfo(classno,Classname) value('002','日语');
insert into Tbl_ClassInfo(classno,Classname) value('003','英语');
-------------------------成绩表---------------------------------
create table Tbl_ScoreInfo
(
Stuno Char(5) not null,
Class Varchar(3) not null,
score int(3),
primary key(Stuno,Class)
);
insert into Tbl_ScoreInfo(Stuno,Class,score) value('05001','001','95');
insert into Tbl_ScoreInfo(Stuno,Class,score) value('05001','002','90');
insert into Tbl_ScoreInfo(Stuno,Class,score) value('05001','003','88');
insert into Tbl_ScoreInfo(Stuno,Class,score) value('05002','001','91');
insert into Tbl_ScoreInfo(Stuno,Class,score) value