Home » Other » General » Movie Database Project
Movie Database Project [message #568818] Tue, 16 October 2012 19:23 Go to next message
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?




Re: Movie Database Project [message #568819 is a reply to message #568818] Tue, 16 October 2012 19:40 Go to previous messageGo to next message
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.
Re: Movie Database Project [message #568823 is a reply to message #568818] Tue, 16 October 2012 23:47 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Use Cases
Next Topic: when user trying to connect from clent side it says no longer available
Goto Forum:
  


Current Time: Thu Mar 28 12:10:51 CDT 2024