CREATE TABLE people_job_in_movie
(
PEOPLE_ID int not null,
MOVIE_ID int not null,
JOB_ID int not null ,
PRIMARY KEY (PEOPLE_ID, MOVIE_ID, JOB_ID),
INDEX (JOB_ID, MOVIE_ID),
FOREIGN KEY FK_PEOPLE (PEOPLE_ID)
REFERENCES people(ID)
ON UPDATE RESTRICT
ON DELETE RESTRICT,
FOREIGN KEY FK_PJ_MOVIE (MOVIE_ID)
REFERENCES movie(ID)
ON UPDATE…