Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2015
    Posts
    2

    Student taking a DB class with a question

    All,

    Just need a little bit of help. I am taking class about database design and management and need to develop an ERD for a database with the below specs:

    An Art Museum that needs to track the artwork, artists, and locations where the art is displayed or stored within the museum. You must support tracking the artist for artwork where there is more than one artist (collaboration)

    I have attached my visio diagram as a JPG.

    Can I please get feedback on if I am going down the right path?

    One other quick question. How do you display cardinality on the ERD in visio?

    Thanks!

    Jake
    Attached Thumbnails Attached Thumbnails DBM.jpg  

  2. #2
    Join Date
    Apr 2015
    Posts
    5
    Have you learnt specialization hierachy?

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Quote Originally Posted by jnconar View Post

    Can I please get feedback on if I am going down the right path?
    No, I don't think you are. The model as it is does not "support tracking the artist for artwork where there is more than one artist (collaboration)". Also, I don't believe you don't need two tables for location.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •