I'm new to database design so please bear with me. I'm using PHP and MySQL. I have a 'movies' table that contains some details about a movie. This includes genres, which have an (if I understand correctly) many to many relationship with movies, implying a single movie can belong to different genres and a single genre can belong to different movies.I'm new to database design so please bear with