Hi all,
not sure if any of you can help with this, but I am struggling that much I'm willing to try. First off, this is for a uni assignment so if your not willing to help I understand. I am not looking for answers, just help.
Basically I have a discourse and have to create an entity-attribute relationship diagram for it. However, for some reason I am really struggling with this, even though I did it last year and a couple of years ago at college.
The part I am struggling with is the following;
Quote:
Artists create works of art. The artist and work of art may be part of an art movement or genre e.g. cubist, expressionist. The artist and works may belong to more than one movement as an artist can produce different kinds of work, and a work can show elements from different movements.
|
So i currently have
Artist (1..*) belongs_to Movement (1..*)
now this is where I am having a problem. I cannot think of a new table to split up the many to many relationship. I have tried;
Artist belongs_to Movement_type
Movement_type is_a Movement
but this way I still get many to many relationships
If anyone could point me in the direction of some help or advise me on how you do modelling then that would be great. And sorry if this seems really confusing. I tried to explain as best I could.
Any help would be greatly appreciated
Dev Articles Community Forums Sponsor:
April 19th, 2007, 07:02 AM
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
