[UPHPU] Database Speed Question

[Jennifer Charrey]

Ah, I was not understanding how you were planning to use the rating  
ID. Makes sense now.

..........................
Jennifer Charrey
jcharrey at xmtp.net


On Apr 11, 2007, at 3:18 PM, Webot Graphics wrote:

>> If by Rating_Description you mean "Parental guidance suggested" or  
>> something like that then neither of your original schema are  
>> properly normalized because you'd be repeating that data thousands  
>> or millions of times.
>
> Why wouldn't my first ones be normalized? I don't know what  
> information would be repeated. This is the information that I would  
> have (by no means is it meant to be exact)
>
> -------------- Movie Table --------------
> Movie_ID: 1, 2, 3
> Movie_Title: Little Rascals, The Incredibles, Pirates of the Caribbean
> Movie_Year_Released: 1994, 2005, 2005
> Rating_ID: 2, 2, 3
>
> -------------- Rating Table --------------
> Rating_ID: 1, 2, 3
> Rating_Code: G, PG, PG-13
> Rating_Description: Good clean fun, Parental Guidance needed, 13  
> and Over with Parental Guidance
>
> Justin Giboney
> www.forodeherbales.com
>
>
>
> _______________________________________________
>
> UPHPU mailing list
> UPHPU at uphpu.org
> http://uphpu.org/mailman/listinfo/uphpu
> IRC: #uphpu on irc.freenode.net