[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