Posted on 2007-04-06
Last Modified: 2012-08-14
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
Primary Keys:


Foreign Key:
Within Movie entity I have Foreign Keys as

Question by:shoris
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 18864254
download this sample from M$

look how the table relationship is set
LVL 65

Accepted Solution

rockiroads earned 500 total points
ID: 18864323
Obviously plenty of many to many
you need to break this down and create junction tables

How are you tables setup now?

Something like this?

Movie (MovieID, Name, etc)
Actor (ActorID, etc)
Customer (CustomerID, etc)
Director (DirectorID, etc)
Rating (RatingID, etc)
Organisaton (OrgID,etc)
Cinema (CinemaID, etc)

To define a movie then u would have multiple rows cos of the many actors, directors etc


MovieActor (MovieID - link to table Movie, ActorID - link to table Actor)

MovieDirector (MovieID, DirectorID)

You can have it as one table i.e.
actorid, directorid, etc

But I suggested to split it up so as to remove duplicate data

How does that sound?

Author Comment

ID: 18864359
I can't load it because i have used up my winzip eval for now.. :( the download is winzip

Author Comment

ID: 18864370
Thanks rockiroads:.. I will split up .. your right.. to avoide the duplicate data.. Thanks again.. so much.

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS Access Query Question 2 36
Null or "" 28 53
MS Access VBA For Each Field Designation 3 19
ListData refresh onClick 5 12
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question