Posted on 2007-04-06
ERD ..i was hoping to get some suggestions and point of view and/or tips if this ERD made sense the way i created it.
Movie: Actor, customer, Director, Rating Organization, Cinema.
One or more actors appear in one or more movies.
Director creates one or more movie while movie is directed by one or more directors
Customer watches one or more movies while a movie is watched one or more customer.
Movie is rated by a rating organization while an independent organization rates one or more movies.
Movie is played in many cinema while cinema plays one movie at a time
An actor has 1:M relationship with movie
Director has 1:M relationship with movie
a customer has 1:M relationship with movie
rating organization has 1:M relationship
cinema has 1:M relations
Within Movie entity I have Foreign Keys as