A database for Yahoo Movies

Do you ever find that, when you want to see a specific movie, you have to check all the cinema ads to find where it is playing? This isn't such a problem for the block-busters, but for smaller arty films it can be quite difficult to find out where you can see a film!

Imagine that we're being paid big bucks by Yahoo! Australia to design a database system with a difference. Rather than the normal listings in the paper that are sorted by Cinema first and then by movie, this one will allow us to also create a list showing, for each movie, all the cinemas where the movie is showing!

We'll divide into groups of 3, and it'll be up to your group to decide on what fields you need, and how to design your tables. Part of what we'll discover together is what's known as database normalization!