CREATE TABLE "MOVIE_PREFERENCES"
(
"ID" NUMBER (5) NOT NULL,
"AGE_CATEGORY" NUMBER (1) NOT NULL,
"GENDER" VARCHAR2 (1),
"MVE_ID_1" NUMBER (3) NOT NULL,
"MVE_ID_2" NUMBER,
"MVE_ID_3" NUMBER
)
;
CREATE TABLE "AGE_CATEGORIES"
(
"ID" NUMBER (1) NOT NULL,
"DESCRIPTION" VARCHAR2 (50)
)
;
CREATE TABLE "MOVIES"
(
"ID" NUMBER (3) NOT NULL,
"TITLE" VARCHAR2 (100)
)
;
ALTER TABLE "AGE_CATEGORIES"
ADD CONSTRAINT "AGE_CATEGORIES_PK1" PRIMARY KEY
(
"ID"
)
 ENABLE
;
ALTER TABLE "MOVIES"
ADD CONSTRAINT "MOVIES_PK" PRIMARY KEY
(
"ID"
)
 ENABLE
;
ALTER TABLE "MOVIE_PREFERENCES"
ADD CONSTRAINT "MPE_ACY_FK1" FOREIGN KEY
(
"AGE_CATEGORY"
)
REFERENCES "AGE_CATEGORIES"
(
"ID"
) ENABLE
;
ALTER TABLE "MOVIE_PREFERENCES"
ADD CONSTRAINT "MPE_MVE_FK1" FOREIGN KEY
(
"MVE_ID_1"
)
REFERENCES "MOVIES"
(
"ID"
) ENABLE
;
ALTER TABLE "MOVIE_PREFERENCES"
ADD CONSTRAINT "MPE_MVE_FK2" FOREIGN KEY
(
"MVE_ID_2"
)
REFERENCES "MOVIES"
(
"ID"
) ENABLE
;
ALTER TABLE "MOVIE_PREFERENCES"
ADD CONSTRAINT "MPE_MVE_FK3" FOREIGN KEY
(
"MVE_ID_3"
)
REFERENCES "MOVIES"
(
"ID"
) ENABLE
;