Creating My DVD Movie Database

Stephen stephen-d-bJEeYj9oJeDQT0dZR+AlfA at public.gmane.org
Sun Jul 4 02:36:25 UTC 2010


I have about 300 DVD movies.

I would like to create a database to support queries.

Movie Title
Director
Actors
Themes

I will use MySQL.

Probably PHP and a web interface.

The work I am looking to simplify is the data entry. Specifically the 
One->Many relationship between movie title and actors.

All tables will be normalized, and there will be a relationship table 
for the movie_id>actor_id.

Any all suggestions appreciated.

Stephen
--
The Toronto Linux Users Group.      Meetings: http://gtalug.org/
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists





More information about the Legacy mailing list