Bluray Database

Quote

Actor table
id (primary key)
first name
last name
etc. (any additional columns you want to store on an actor)

Director table
id
first name
last name
etc.

Genre table
id
name
etc.

Film table
id
title
description
running time
release date
director id -- this is a foreign key that refers to the id (the primary key) of the director who directed the film
genre id -- like the director id, this refers to the id of the genre the film belongs to

Actor-film index table
film id -- this is a foreign key that refers to the id of the film
actor id -- this is a foreign key that refers to the id of one actor in the film.

------------------

Films => Primary Key(filmid), Unique Constraint(filmtitle, year),
runningtime, description,
Foreign Key(Genre), Foreign Key(DirectorId)

Genre Table => Primary Key(Genre)

Director Table => Primary Key(DirectorId), DirectorName

Actors Table => Primary Key(ActorId), ActorName

Films_Actors => Primary Key(Foreign Key(ActorId), Foreign Key(FilmId))

Source: http://stackoverflow.com/questions/490464/how-to-design-a-movie-database