Theatre database

[Banaticus]

I'm going to create a theatre database, but I'm having trouble creating the basic relationships of the tables.

We have multiple shows and I want to be able to add shows in the future. Each show has a Cast and a Crew. Each Cast/Crew list is populated from a Contacts table (names, phone #'s, emails). Any advice would be welcome.

New people are added to the Contacts table, which holds everyone.

 

[KeithG]

You need a table for Movies, a table for Cast, and MovieCast table. MovieCast will contain the PK form Movies and the PK from Cast.