Error Code: 1215. --Cannot add foreign key constraint

Question

create database university;
use university;

create table department
    (dept_name varchar(20),
     building  varchar(15),
     budget    numeric(12,2),
     primary key(dept_name));

create table course 
    (course_id   varchar(7),
     title       varchar(50),
     dept_name   varchar(20),
     credits     numeric(2,0),
     primary key(course_id),
     foreign key(dept_name) references department);

Answer 1

You missed specifying the target column of the department table

foreign key(dept_name) references department(dept_name));