Movie Database Project [message #568818] |
Tue, 16 October 2012 19:23 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](//www.gravatar.com/avatar/e6390075af8701c46b7d5e7d16f58a70?s=64&d=mm&r=g) |
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?
|
|
|
|
|