mysql建表:createtablecourse(idvarchar(40)primarykey,namevarchar(100)notnull,creditintnotnull,teachernamevarchar(100)notnull,gendervarchar(40)notnull,imagevarchar(40),cla...
mysql建表:
create table course
(
id varchar(40) primary key,
name varchar(100) not null,
credit int not null,
teachername varchar(100) not null,
gender varchar(40) not null,
image varchar(40),
class_id varchar(40),
constraint class_id_FK1 foreign key(class_id) references class(id)
);
create table student
(
id varchar(40) primary key,
studentid varchar(100) not null,
name varchar(100) not null,
password varchar(100) not null,
gender varchar(40) not null,
class_id varchar(40),
constraint class_id_FK foreign key(class_id) references class(id)
);
create table result
(
student_id varchar(40),
course_id varchar(40),
score int,
constraint student_id_FK foreign key(student_id) references student(id),
constraint course_id_FK foreign key(course_id) references course(id),
primary key(student_id,course_id)
);
create table class
(
id varchar(40) primary key,
name varchar(100) not null,
description varchar(255)
);
course课程,result是成绩,student是学生,course、
与student多对多
成绩是联合主键,且与学生表课程表关联,
class是班级
课程和学生表与班级关联
这样设计一个学生成绩管理系统是否合理?要是使用jdbc操作 如何加上级联删除更新和保存什么的
展开