[UPHPU] Database Speed Question

Webot Graphics graphics at westernbotanicals.com
Wed Apr 11 14:05:18 MDT 2007


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




More information about the UPHPU mailing list