OraFAQ Forum: General » Movie Database Project

Home » Other » General » Movie Database Project

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Movie Database Project [message #568818]

Tue, 16 October 2012 19:23

migoysplace
Messages: 4
Registered: October 2012

Junior Member

Hey,

I am working on a project for a movie database
I have 3 entities ( Movie, Theater, TimeShow)
The showtime is going to be my intersection entity for this database. The ID's for Movie and Theater as the foreign composite keys

I'm just a little confuse on the normalization part for the Timeshow intersection entity since every movie has 2 different start times

My TimeShow tables looks like this

THEATERID
01
MOVIEID
02
SHOWTIMES
5:00pm

THEATERID
01
MOVIEID
02
SHOWTIMES
10:00pm

Does this violate any normalization rules? Do i have to make all SHOWTIMES as part of the composite key too?

Report message to a moderator

Re: Movie Database Project [message #568819 is a reply to message #568818]

Tue, 16 October 2012 19:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Please NOTE the subject of this forum which is SQL & PL/SQL; so I must ask why you did not post any actual SQL statements?
I don't see any Primary Key or Foreign Key.

Report message to a moderator

Re: Movie Database Project [message #568823 is a reply to message #568818]

Tue, 16 October 2012 23:47

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Welcome to the forum.

Please post the complete description of your table.
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Have a llok at Normalization wiki page.

Regards
Michel

Report message to a moderator

Previous Topic:	Use Cases
Next Topic:	when user trying to connect from clent side it says no longer available

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 22:02:47 CST 2024