Movies at Cinema Design help

From: Garuda <garuda_at_spammers.bye>
Date: Sun, 29 Sep 2002 04:05:23 +0700
Message-ID: <an55io$c4e$1@news.cscoms.com>

Hello,
I have to design a database that handles the movies displayed in a cinema with multiple rooms.

It means that a movie could be displayed in multiple rooms at the same time, and different movies can be displayed in the same room at different times.

How it's done?
If I try to make it normalized, to eliminate redundancy, I start to don't understand anything.

It should be a M:M relationship between the movie and the room, and a 1:M between the movie and the time. And, oh.. what a mess!

Can somebody please give me some help?
Thank you,
Garuda Received on Sat Sep 28 2002 - 16:05:23 CDT