Expert: Philip Lafeber - 6/15/2004

Question
Hi,

I would appreciate some help with the following question, I have done it myself, but I'm not sure its correct:

Draw the following relationships: a) An art gallery schedules one or more exhibits; a particular exhibit is scheduled for only one art gallery; b) An exhibit may involve the artwork of many artists; an artist's artwork may be exhibited at one or more art galleries, or may not be exhibited; c) For each exhibit there is one director; a director may direct one exhibit in a given art gallery, or may not direct any exhibits. Indicate minimum and maximum cardinalities, degree and optional/mandatory nature of each relationship.

This is what I came up with:

       1                  0 or M  
 Art    ------------ Exhibits ---------- Artwork
Gallery       1 or M    |           1 or M
                              |
                              | 0 or 1
                   1        |
          Director --------|


Entities:
Art Gallery, Exhibits, Artwork, Director


1. Would artwork be an entity?
2. Are all the relationships shown correctly?
3. Any entities I missed (eg. associative)?
4. Is this correct overall?
5. I know what cardinaltiy and optional/mandatory nature of relation are, but what is degree?

Any help would be greatly appreciated. Thanks.

Answer
Hello,
Thank you for your question. I apologise for replying so late. I was not available earlier.
Your start is correct; creating an overview of the important items in the project description, and linking them together. From what you wrote, I am not able to see if it is correct. But from what I can see, it looks right. I would also like to ask if you can check that ALL items that play a role in this project were represented in your diagram. I think I am missing one. Just find all nouns in the text and decide whether they are particular for this topic.

Good luck!
Regards,
Philip.