[UPHPU] Database Speed Question

[Brandon Stout]

Webot Graphics wrote:
> Here is the database that I have now. Anyone have any suggestions?
>
> Movie Database
>
> Movies Table
>     Movie_ID
>     Plot_Description
>     
> Movie_Relationships Table
>     Movie_Relationship_ID
>     Movie_ID
>     Movie_Title
>     Movie_Description
>     Country_ID
>     Language_ID
>     Movie_Release_Year
>     DVD_Release_Year
>     Movie_Release_Month
>     DVD_Release_Month
>     Movie_Release_Day
>     DVD_Release_Year
>     Movie_Runtime
>     Front_Cover_Image_File
>     Back_Cover_Image_File
>     
> Trailers Table
>     Trailer_ID
>     Trailer_File
>     Movie_Relationship_ID
>     
> Extra_Features Table
>     Extra_Feature_ID
>     Extra_Feature_Name
>     
> Extra_Feature_Movie_Relationships Table
>     Extra_Feature_ID
>     Movie_ID
>     
> Subtitle_Movie_Relationships Table
>     Language_ID
>     Movie_ID
>     
> Languages Table
>     Language_ID
>     Language_Name
>
> Genres Table
>     Genre_ID
>     Genre_Name
>     
> Genre_Movie_Relationships Table
>     Genre_ID
>     Movie_ID
>
> Actors Table
>     Actor_ID
>     Actor_First_Name
>     Actor_Last_Name
>     
> Actor_Movie_Relationships Table
>     Actor_ID
>     Movie_ID
>
> Producers Table
>     Producer_ID
>     Producer_First_Name
>     Producer_Last_Name
>     
> Producer_Movie_Relationships Table
>     Producer_ID
>     Movie_ID
>
> Directors Table
>     Director_ID
>     Director_First_Name
>     Director_Last_Name
>     
> Director_Movie_Relationships Table
>     Director_ID
>     Movie_ID
>
> Production_Companies Table
>     Production_Company_ID
>     Production_Company_Name
>     
> Production_Company_Movie_Relationships Table
>     Production_Company_ID
>     Movie_ID
>
> Ratings Table
>     Rating_ID
>     Rating_Code
>     Rating_Description
>     Rating_Country_ID
>     
> Countries Table
>     Country_ID
>     Country_Name
>     
> Rating_Movie_Relationships Table
>     Rating_ID
>     Movie_ID
>
> Barcodes Table
>     Barcode
>     Barcode_Movie_ID
>     Full_Screen (BOOL/False is wide screen)
>
>
>
> Justin Giboney
> www.forodeherbales.com

Justin,

You will have different release dates for both the movie and the dvds 
for different countries.

Brandon Stout
http://mscis.org