数据库设计：课程表、教师表、班级表示例

CREATE TABLE kc ( id int PRIMARY KEY, 'name' varchar(50), xf int, xq int );

CREATE TABLE js ( id int PRIMARY KEY, 'name' varchar(50), year int, kid int, FOREIGN KEY (kid) REFERENCES kc(id) );

CREATE TABLE bj ( id int PRIMARY KEY, 'name' varchar(50), zy varchar(50), yx varchar(50) );