Results 1 to 14 of 14
  1. #1
    Join Date
    Feb 2012
    Posts
    7

    Help with this erd

    Can someone please help me. i have to find 3 things wrong with this erd but have no idea what im looking for. i have to Choose three different structural features of the design which could be improved.
    •Describe the structural feature
    •Give one or more examples of where it is incorrectly modelled in the design
    •Explain the effect that this would have on the ability to retrieve information
    •Missing attributes and incorrect keys are NOT structural features.

    Can someone please help
    Attached Thumbnails Attached Thumbnails 17-02-2012 12-42-43.png  

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Sorry, we don't do homework on this site.

    Best we can offer is advice on your own attempts - so why not give it a go and let us know how you get on
    George
    Home | Blog

  3. #3
    Join Date
    Feb 2012
    Posts
    7
    Sorry i put the wrong one up. this is the one that i have done. Can you tell me if its correct please.
    Attached Files Attached Files

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    how would we know whether its 'correct'
    we don't know what the design brief is
    we dont' know how deta\iled your assessment is

    here's an idea
    either supply us the name person teaching you this stuff, where they are based so we can cut out the middle man
    OR
    talk to your fellow students or talk to the person setting the work yourself.
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Feb 2012
    Posts
    7
    As it states in the first post

    Give one or more examples of where it is incorrectly modelled in the design. The design is also above. And i have tried asking my tutor but his teaching skills are not that good with someone that has learning difficulties.

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by cityboys View Post
    Can you tell me if its correct please.
    no idea, i can't open that file

    is it some type of proprietary software?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Feb 2012
    Posts
    7
    Its in micosoft word.

  8. #8
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    in other words (no pun intended), yes, proprietary software
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  9. #9
    Join Date
    Feb 2012
    Posts
    7
    So you carnt open a word document! Mmm.... thanks for the help.

  10. #10
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by cityboys View Post
    So you carnt open a word document! Mmm.... thanks for the help.
    that is correct

    the onus is on you to display your ERD in a fashion which does not require me to go and purchase proprietary software

    let me give you a hint: .gif, .jpg, and .png work just fine

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  11. #11
    Join Date
    Feb 2012
    Posts
    7
    Ok. heres a png of it.
    Attached Thumbnails Attached Thumbnails 19-02-2012 13-05-43.png  

  12. #12
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you'll need to rationalize some of the lines and foreign keys in the diagram

    for example, you have a service belonging to a branch and a membership, but there's only one line from service to branch and none to membership

    also, you have garment belonging to both branch and member, not no foreign keys in the garment
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  13. #13
    Join Date
    Feb 2012
    Posts
    7
    Thanks i have been told to ignore all keys and attributes and concentrate on the structure, so with that in mind how does it look?

  14. #14
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by cityboys View Post
    ...so with that in mind how does it look?
    like there might be lines missing, and possibly some of the crowsfeet might be wrong
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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