创建department表:
create table department(
dept_name varchar(20),
budget int,
descript varchar(20),
primary key(dept_name)
);
创建course表:
create table course(
course_id varchar(20),
dept_name varchar(20),
credits int,
foreign key(dept_name) references department(dept_name));
查看department表:
查看course表: