CREATE TABLE ACTOR (
    ACTOR_ID    DECIMAL (2,0) PRIMARY KEY NOT NULL,
    ACTOR_FIRST CHAR(25),
    ACTOR_LAST  CHAR(30),
    DOB         DATE
);

CREATE TABLE DIRECTOR (
    DIRECTOR_ID     DECIMAL(2,0) PRIMARY KEY NOT NULL,
    DIRECTOR_FIRST  CHAR(25),
    DIRECTOR_LAST   CHAR(30)
);

CREATE TABLE FILM (
    FILM_ID         DECIMAL(2,0) PRIMARY KEY NOT NULL,
    TITLE           CHAR(50),
    RELEASE_DATE    DATE,
    DIRECTOR_ID     DECIMAL(2,0),
    GENRE_ID        CHAR(10),
    PRODUCTION_ID   CHAR(3)
);

create view film_production as
select
    title,
    actor_first,
    actor_last,
    director_first,
    director_last,
    Production_id,
    release_date
from    film,
        actor,
        director
;