Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

ERD question

  • 19-11-2014 06:38PM
    #1
    ibstar
    Registered Users, Registered Users 2 Posts: 373 ✭✭


    I'm mapping an ERD for an assignment, which is broken down into 2 parts (ERD and UML).
    I have all the relationships mapped out to answer part one about ERD, except for one little nuance.

    The ERD is based on a DB of papers submitted by authors and reviewers that can access these papers.

    We are told that once 3 reviewers select a single paper for review, it disappears from the view of other reviewers.

    Is there a way to show this on an ERD, or this is related to UML?
    (we're only starting UML, so part 2 of assignment is not due for a while)

    thanks ;)


Comments

  • #2
    CruelCoin
    Registered Users, Registered Users 2 Posts: 4,463 ✭✭✭CruelCoin


    Hi,

    Fellow newbie here.

    You could have it that you have an extra field called hidden, with values of 1 or 0, or true/false, etc.

    Accessing an entry changes that entry's value to 1/true.

    Modify your select statement for the other researchers to only return entries with a hidden field value of 0 or false.

    Again, fellow nebie, not tried this. Looking forward to seeing some pro answers.


  • #3
    Tom Dunne
    Registered Users, Registered Users 2 Posts: 23,202 ✭✭✭✭Tom Dunne


    Bizarrely, I am working on an identical system, with an identical problem. Mad. Except, I'm not a student.

    Anyway, the question you need to ask is does the paper need to disappear, or should it simply not appear under certain circumstances?


  • #4
    ibstar
    Registered Users, Registered Users 2 Posts: 373 ✭✭ibstar


    thank you for replies.

    the question for now is if I need to show in some shape or form on my ERD, that a paper disappears from other reviewers views, if the paper is selected by 3 other reviewers.

    I don't think there is a way to do this with an ERD, but possible with UML. I may be jumping ahead of myself here.


Advertisement