先创建课程表:
mysql> create table course(
-> course_no int unsigned auto_increment,
-> course_name varchar(100) not null,
-> course_credit int unsigned not null,
-> course_type varchar(20) not null,
-> primary key(course_no));
再创建教师表:此处已添加单个外码约束teacher_dept
mysql> create table teacher(
-> teacher_no int unsigned auto_increment,
-> teacher_name varchar(100),
-> teacher_title varchar(20) not null,
-> teacher_dept int unsigned not null,
-> primary key(teacher_no),
-> foreign key(teacher_dept) references department(dept_no));
创建任课表:此处添加两个外码约束teacher_no和course_no
mysql> create table teach(
-> teacher_no int unsigned,
-> course_no int unsigned,
-> primary key(teacher_no,course_no),
-> foreign key(teacher_no) references teacher(teacher_no),
-> foreign key(course_no) references course(course_no));