Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2008
    Posts
    7

    Movie database design

    Hi folks

    I am trying to come up with a good design for a movie database.
    The information I want to store about each movie is:
    Title, Actors, Genres, Writers, Director(s), Country, Year, Running Time, Rating, Keyword

    It must be possible to search by any of these, and any combination of these.
    I figured Actors, Writers and Director(s) are persons and can as such be stored as a separate "Person" db.
    Should I also detach for example genre or country or keywords as separate tables? I know one movie can have several genres and vice versa.
    And if so, how should I link for instance genres to the movie table?

    I am quite a newbie in databases, so please forgive my infantile questions.
    I just want to have a robust and strong database that can handle multiple searches on any column.

    Thanks.

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Do you know what a many-to-many relationship is? And, how it is implemented in a relational database?
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •