New Database Design
I want to create a database to track actors and roles, I suppose something like the iMdb. Here is what I want to be able to do.
I want to have a group of shows and each show can have multiple actors and each actor can have multiple roles. I would like to be able to then assign each actor in that role in each episode a group of lines. Currently I am thinking that it would be a SHOW table, a ACTOR table, a LINES table, and a ROLES table. I would think that there would have to be a many to many with join tables between SHOW and ACTOR and SHOW and ROLE. However, I don't know if that is the most efficient design.
If it is not too much to ask, what would be the best way to cross reference all this information once the basic structure is intact? Again, something like iMdb (though not a web based navigation) is what seems to make the most sense to me.
Thanks and if I was unclear on anything please let me know,