2.2.12.sql

清华大学出版社出版的数据库系统教程附带的实验教程中所有的源代码

use school
create table listen_course (
    teacher_id char(6),tname varchar(20),course_id char(4)
    constraint PK_listen_course primary key(teacher_id)
    constraint FK_listen_course foreign key(course_id) 
                                references teach_course(course_id)
)
create table teach_course(
    course_id char(4),cname varchar(30),teacher_id char(6)
    constraint PK_teach_course primary key(course_id)
    constraint FK_teach_course foreign key(teacher_id) 
                               references listen_course(teacher_id)
)