Many-To-Many Relationship
Posted: Tue Apr 12, 2011 7:54 am
Hi,
I am looking for suggestions as to how I might model a many-to-many relationship in a database.
For example consider a table of actors and actresses and a table of movies. An actor may appear in many movies and a movie will feature many actors. How do I account for the fact that an actor might feature in 100 movies - I can't have a field for each movie.
I can't figure this out.
Thansk in advance,
Rob.
I am looking for suggestions as to how I might model a many-to-many relationship in a database.
For example consider a table of actors and actresses and a table of movies. An actor may appear in many movies and a movie will feature many actors. How do I account for the fact that an actor might feature in 100 movies - I can't have a field for each movie.
I can't figure this out.
Thansk in advance,
Rob.