[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