[UPHPU] Database Speed Question

[Walt Haas]

I don't think you need the relationships table unless you have a
many-to-many relationship between movies and ratings.

On Wed, 2007-04-11 at 14:05 -0600, Webot Graphics wrote:
> I am preparing to do a movie database of dvds that a friend of mine has.
> 
> In a one to many relationship, such as movie ratings (each movie  
> having only a US rating for sanity purposes) would it be faster or  
> easier on the database to do
> 
> this:
> 
> Movies Table
> 	Movie_ID
> 	Movie_Title
> 	Movie_Year_Released
> 	Rating_ID (linked to Ratings Table)
> 
> Ratings Table
> 	Rating_ID
> 	Rating_Code
> 	Rating_Description
> 
> or this:
> 
> Movies Table
> 	Movie_ID
> 	Movie_Title
> 	Movie_Year_Released
> 
> Ratings Table
> 	Rating_ID
> 	Rating_Code
> 	Rating_Description
> 
> Rating_Movie_Relationships Table
> 	Rating_ID
> 	Movie_ID
> 
> 
> Which one would be the correct way (as per normalization)?
> 
> 
> Justin Giboney
> Western Botanicals
> Ph:800.651.4372, Fax:866.366.4372
> 
> 
> 
> _______________________________________________
> 
> UPHPU mailing list
> UPHPU at uphpu.org
> http://uphpu.org/mailman/listinfo/uphpu
> IRC: #uphpu on irc.freenode.net