drop table THEATERS;
create table THEATERS (
  TNAME varchar(50), 
  ADDRESS varchar(50), 
  PHONE varchar(50));

insert into THEATERS values 
('Odeon', '123 Main Street', '111-1111');
insert into THEATERS values 
('Plaza', '234 Oak Street', '111-1112');

drop table PLAYS;
create table PLAYS (
  TNAME varchar(50), 
  TITLE varchar(50), 
  STARTTIME varchar(50));

insert into PLAYS values 
('Odeon', 'Frenzy', '9.00');
insert into PLAYS values 
('Odeon', 'Ran', '8.00');
insert into PLAYS values 
('Plaza', 'Frenzy', '9.00');
insert into PLAYS values 
('Plaza', 'Godfather', '11.00');

drop table MOVIES;
create table MOVIES (
  TITLE varchar(50), 
  DIRECTOR varchar(50));

insert into MOVIES values 
('Godfather', 'Coppola');
insert into MOVIES values 
('Godfather II', 'Coppola');
insert into MOVIES values 
('Frenzy', 'Hitchcock');
insert into MOVIES values 
('Ran', 'Kurosawa');
insert into MOVIES values 
('Ran II', 'Kurosawa');
insert into MOVIES values 
('Nora Inu', 'Kurosawa');
insert into MOVIES values 
('Inubue', 'Kikushima');

drop table ACTORS;
create table ACTORS (
  TITLE varchar(50), 
  ACTOR varchar(50));

insert into ACTORS values 
('Godfather', 'Brando');
insert into ACTORS values 
('Godfather', 'Duvall');
insert into ACTORS values 
('Godfather', 'Pacino');
insert into ACTORS values 
('Godfather II', 'Brando');
insert into ACTORS values 
('Godfather II', 'Duvall');
insert into ACTORS values 
('Godfather II', 'Stewart');
insert into ACTORS values 
('Frenzy', 'Hitchcock');
insert into ACTORS values 
('Frenzy', 'Stewart');
insert into ACTORS values 
('Ran', 'Nakadai');
insert into ACTORS values 
('Ran', 'Nezu');
insert into ACTORS values 
('Ran', 'Terao');
insert into ACTORS values 
('Ran II', 'Brando');
insert into ACTORS values 
('Ran II', 'Duvall');
insert into ACTORS values 
('Ran II', 'Hitchcock');
insert into ACTORS values 
('Ran II', 'Nakadai');
insert into ACTORS values 
('Ran II', 'Pacino');
insert into ACTORS values 
('Ran II', 'Stewart');
insert into ACTORS values 
('Ran II', 'Sugawara');
insert into ACTORS values 
('Nora Inu', 'Akari');
insert into ACTORS values 
('Nora Inu', 'Nezu');
insert into ACTORS values 
('Nora Inu', 'Terao');
insert into ACTORS values 
('Nora Inu', 'Watari');
insert into ACTORS values 
('Inubue', 'Nezu');
insert into ACTORS values 
('Inubue', 'Sugawara');
insert into ACTORS values 
('Inubue', 'Terao');

