[UPHPU] Database Speed Question

Webot Graphics graphics at westernbotanicals.com
Wed Apr 11 15:18:56 MDT 2007


> 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




More information about the UPHPU mailing list