PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE Actor(
  actor VARCHAR(20),
  yearBorn SMALLINT
);
INSERT INTO Actor VALUES('Cage',1964);
INSERT INTO Actor VALUES('Hanks',1956);
INSERT INTO Actor VALUES('Maguire',1975);
INSERT INTO Actor VALUES('McDormand',1957);
CREATE TABLE Director(
  director VARCHAR(20),
  yearBorn SMALLINT
);
INSERT INTO Director VALUES('Coen',1954);
INSERT INTO Director VALUES('Hanson',1945);
INSERT INTO Director VALUES('Raimi',1959);
CREATE TABLE StarsIn(
  actor VARCHAR(20),
  movie VARCHAR(20)
);
INSERT INTO StarsIn VALUES('Cage','Raising Arizona');
INSERT INTO StarsIn VALUES('Maguire','Spiderman');
INSERT INTO StarsIn VALUES('Maguire','Wonder Boys');
INSERT INTO StarsIn VALUES('McDormand','Fargo');
INSERT INTO StarsIn VALUES('McDormand','Raising Arizona');
INSERT INTO StarsIn VALUES('McDormand','Wonder Boys');
CREATE TABLE Movie(
  title VARCHAR(20),
  director VARCHAR(20),
  year SMALLINT,
  rating DECIMAL(2,1)
);
INSERT INTO Movie VALUES('Fargo','Coen',1996,8.1999999999999992894);
INSERT INTO Movie VALUES('Raising Arizona','Coen',1987,7.5999999999999996447);
INSERT INTO Movie VALUES('Spiderman','Raimi',2002,7.4000000000000003552);
INSERT INTO Movie VALUES('Wonder Boys','Hanson',2000,7.5999999999999996447);
COMMIT;
