建表时，用MySQL语句为属性创建外键关联

1.创建department表

 create table department(
     id int primary key,
     director varchar(50) not null,
     area varchar(50) check('南湖校区'or'浑南校区')
 )

2.创建classes表，并为department_id属性创建外键关联

create table classes(
    id int primary key,
    name varchar(50) unique,
    department_id int,
    constraint classes_fk foreign key(department_id) references department(id)
)

notes:classes_fk：约束名

          department(id)：classes表所关联的表department的主键