创建以下两个表:
#请在此添加创建开课信息表和教师信息表的SQL语句
########## Begin ##########
use universityDB;
create table instructor(
ID varchar(5) primary key,
name varchar(20) not null,
dept_name varchar(20),
salary numeric(8,2) check(salary>29000),
foreign key(dept_name) references department(dept_name)
);
create table section(
course_id varchar(8),
sec_id varchar(8),
semester varchar(6) check(semester in('Fall','Winter','Spring','Summer')),
year numeric(4,0) check(year>1701 and year<2100),
building varchar(15),
room_number varchar(7),
time_slot_id varchar(4),
primary key(course_id,sec_id,semester,year),
foreign key(course_id) references course(course_id) on delete cascade,
foreign key(building,room_number) references classroom(building,room_number) on delete set null
);
########## End ##########