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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I can't load it because i have used up my winzip eval for now.. :( the download is winzip
ASKER
Thanks rockiroads:.. I will split up .. your right.. to avoide the duplicate data.. Thanks again.. so much.
http://office.microsoft.com/en-us/templates/TC010186441033.aspx?pid=CT102144001033
look how the table relationship is set