Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    78

    can someone check my normalisation?

    hi i have normalised down to BCNF i think and was woundering if someone could check it for me please

    UNF

    Paper No
    Paper Title
    Decision
    Topic
    Authors Name
    Email
    Phone
    Reviewers Name
    Relevance
    Originality
    Technical Merit
    Overall Mark
    Copyright Ok
    Received Ok
    Length Ok
    Format Ok

    1st Normal Form

    Paper No (PK)
    Paper Title
    Decision
    Topic
    Copyright Ok
    Received Ok
    Length Ok
    Format Ok

    Paper No(PK)
    Authors Name(PK)
    Email
    Phone

    Paper No(PK)
    Reviewers Name(PK)
    Relevance
    Originality
    Technical Merit

    2nd Normal Form

    Paper No (PK)
    Paper Title
    Decision
    Topic
    Copyright Ok
    Received Ok
    Length Ok
    Format Ok

    Paper No(PK)
    Authors Name(PK)
    Email
    Phone

    Paper No(PK)
    Reviewers Name(PK)
    Relevance
    Originality
    Technical Merit

    Paper No(FK)
    Authors Name(FK)


    3rd and BCNF are the same

  2. #2
    Join Date
    Feb 2005
    Location
    Colorado Springs
    Posts
    222
    On the 2NF, would a Topic table be in order? Also, could there be a M:M relationship between reviewers and papers? Considering the paper, the review, and the reviewer to be entities, Paper would have 1:M with Review and then Review would have 1:M with Reviewer. Something like that.

  3. #3
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    Here's what you have created. I developed the model using dbdesigner4. It is free to download.

    Does the model look right?
    Attached Thumbnails Attached Thumbnails untitled.JPG  

  4. #4
    Join Date
    Feb 2004
    Posts
    78
    that seems ok to me

    is it wrong?????

  5. #5
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    You have a model which is giving conflicting relationships.

    One paper can have many authors.

    Many papers can have many authors.

    One paper can have many reviewers.

    The many to many relationship makes the most sense.

Posting Permissions

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