drop table faculty cascade constraints;
create table faculty (
  name varchar2(20) primary key
);
drop table schedule cascade constraints;
create table schedule (
  when date primary key,
  who  varchar2(20),
  foreign key (who) references faculty
);
insert into faculty values ('Belkasim');
insert into faculty values ('Beyah');
insert into faculty values ('Bourgeois');
insert into faculty values ('Cao');
insert into faculty values ('Harrison');
insert into faculty values ('Hu');
insert into faculty values ('King');
insert into faculty values ('Li');
insert into faculty values ('Owen');
insert into faculty values ('Pan');
insert into faculty values ('Prasad');
insert into faculty values ('Sunderraman');
insert into faculty values ('Weeks');
insert into faculty values ('Zelikovsky');
insert into faculty values ('Zhang');
insert into faculty values ('Zhu');
insert into faculty values ('NO CLASS');
insert into schedule(when,who) values('10-JAN-2008','Sunderraman');
insert into schedule(when) values(to_date('10-JAN-2008')+7);
insert into schedule(when) values(to_date('10-JAN-2008')+14);
insert into schedule(when) values(to_date('10-JAN-2008')+21);
insert into schedule(when) values(to_date('10-JAN-2008')+28);
insert into schedule(when) values(to_date('10-JAN-2008')+35);
insert into schedule(when) values(to_date('10-JAN-2008')+42);
insert into schedule(when) values(to_date('10-JAN-2008')+49);
insert into schedule(when,who) values(to_date('10-JAN-2008')+56,'NO CLASS');
insert into schedule(when) values(to_date('10-JAN-2008')+63);
insert into schedule(when) values(to_date('10-JAN-2008')+70);
insert into schedule(when) values(to_date('10-JAN-2008')+77);
insert into schedule(when) values(to_date('10-JAN-2008')+84);
insert into schedule(when) values(to_date('10-JAN-2008')+91);
insert into schedule(when) values(to_date('10-JAN-2008')+98);
insert into schedule(when) values(to_date('10-JAN-2008')+105);
