AllExperts > Information Technology 
Search      
Information Technology
Volunteer
Answers to thousands of questions
 Home · More Information Technology Questions · Answer Library  · Encyclopedia ·
More Information Technology Answers
Question Library

Ask a question about Information Technology
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Philip Lafeber
Expertise
I have been specialising in knowledge analysis and modelling. I have an interest in the way models of programs, architectures, business processes and the like are properly made and analysed. What`s meant by `properly` depends on the goal you`re trying to achieve. The analysis of this goal and the way it can best be realised is something you might want to ask me about.

Experience

Past/Present clients
University of Amsterdam, Bolesian, Canon europa, Solveware, NetlinQ

 
   

You are here:  Experts > Industry > IT Consulting > Information Technology > ERD diagram

Information Technology - ERD diagram


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.

Add to this Answer   Ask a Question


 
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.