create table movies(id pkey, ...) create table directors (id pkey, name) create table movie_directors(movie references movies(id), director references directors(id))