CREATE TABLE FILM
( "FILM_ID" NUMBER,
"TITLE" VARCHAR2(20 BYTE),
"DESCRIPTION" VARCHAR2(100 BYTE),
"RELEASE_YEAR" NUMBER,
"LANGUAGE_ID" NUMBER,
"LENGTH" VARCHAR2(20 BYTE),
"REPLACEMENT_COST" NUMBER,
PRIMARY KEY (FILM_ID),
FOREIGN KEY (LANGUAGE_ID) REFERENCES LANGUAGE (LANGUAGE_ID)
);


CREATE TABLE FILM_CATEGORY
( "FILM_ID" NUMBER,
"CATEGORY_ID" NUMBER,
FOREIGN KEY (FILM_ID) REFERENCES FILM (FILM_ID),
FOREIGN KEY (CATEGORY_ID) REFERENCES CATEGORY (CATEGORY_ID)
) ;
CREATE TABLE CATEGORY
( "CATEGORY_ID" NUMBER,
"NAME" VARCHAR2(60 BYTE),
PRIMARY KEY (CATEGORY_ID)
);