116.  To create tables Department and Instructor:

 

create table department

( deptID integer,

  deptname char(30) not null,

  deptchair char(9) not null,

  primary key (deptID),

  unique (deptname));

 

create table instructor

( instID char(9),

  instName char(30) not null,

  depart integer,

  primary key (instID),

  constraint instructor_dept_FK Foreign Key (depart) references department (deptID));

 

alter table department

add constraint department_deptchair_fk

foreign key (deptchair) references instructor (instID);