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_at_news.cscoms.com>
Hello,
I have to design a database that handles the movies displayed in a cinema with multiple rooms.
Date: Sun, 29 Sep 2002 04:05:23 +0700
Message-ID: <an55io$c4e$1_at_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 - 23:05:23 CEST