Link to home
Start Free TrialLog in
Avatar of shoris
shoris

asked on

ERD

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.

Entity:
Movie: Actor, customer, Director, Rating Organization, Cinema.

Relationships:
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

Cardinalities:
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:


MovieID
ActorID
ROrID
AwardID
CusID
DirID

Foreign Key:
Within Movie entity I have Foreign Keys as
ActorID
ROrID
AwardID
CusID
DirID

Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

download this sample from M$

http://office.microsoft.com/en-us/templates/TC010186441033.aspx?pid=CT102144001033

look how the table relationship is set
ASKER CERTIFIED SOLUTION
Avatar of rockiroads
rockiroads
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of shoris
shoris

ASKER

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

ASKER

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