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

    going from 2NF to 3NF (was "sir mix alot")

    "i hate normalisation and i cannot lie"

    hi people
    i am a beginner to normalisation and am having a little trouble going from 2NF to 3Nf .Could n e 1 that reads these forums give me some pointers on which table need normalising to 3rd NF. from what i can see it's just the Author_table and the Reviewers_table that needs it. is this correct?



    UNF

    Paper No
    Paper Title
    Decision
    Topic

    Author’s Name
    Email
    Phone

    Reviewer’s Name
    Relevance
    Originality
    Technical Merit
    Overall Mark

    Copyright OK
    Received OK
    Length OK
    Format OK



    1st Normal Form

    Paper table
    ----------------
    Paper No (PK)
    Paper Title

    Decision_table
    ----------------
    Decision_id (PK)
    Decesion

    Paper_Topics_table
    ----------------
    Topic_id (PK)
    Topic

    Author table
    ----------------
    Author_id (PK)
    First Name
    Surname
    Email
    Phone

    Review table
    ----------------
    Review_id (PK)
    Relevance
    Originality
    Technical Merit
    Overall Mark



    Reviewers_table
    ----------------
    Reviewer_id(PK)
    Reviewer’s First Name
    Reviewer’s Surname
    Phone
    Email


    Manuscript table
    ----------------
    Manuscript_no(PK)
    Copyright OK
    Received OK
    Length OK
    Format OK

    2nd Normal Form

    Paper table
    -------------
    Paper No (PK)
    Paper Title

    Decision_table
    ---------------
    Decision_id (PK)
    Decesion

    Paper_Topics_table
    --------------------
    Topic_id (PK)
    Topic

    Author table
    --------------
    Author_id (PK)
    First Name
    Surname
    Email
    Phone

    Review table
    ---------------
    Review_id (PK)
    Relevance
    Originality
    Technical Merit
    Overall Mark


    Reviewers_table
    ------------------
    Reviewer_id(PK)
    Reviewer’s First Name
    Reviewer’s Surname
    Phone
    Email

    Reviewer_Topic Table
    ---------------------
    Reviewer_id(PK)
    Topic_id

    Manuscript table
    ---------------
    Manuscript_no(PK)
    Copyright OK
    Received OK
    Length OK
    Format OK

  2. #2
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    I see only one relationship between the entities. How are the entities related?

  3. #3
    Join Date
    Feb 2004
    Posts
    78

    Angry

    hi
    thanks for your reply - as i said i am very new to normalisation. but here is the scenario i have been given.

    any help to tell me where i'm going wrong would be great.

    -----------------------------------------------------------------------
    A database is required for supporting the administration of conference proceedings identified below.
    Prospective authors submit papers, which have to be distributed to Programme Committee Members (PCM) for review. Each PCM is willing to review a (unspecified) number of papers that concern a number of (specified) chosen topics. Information stored on topics have a unique topic number and topic name. Each paper has a keyword to state which topic it discusses and must be reviewed by at least one PCM.
    The database is to be used for tracking the progress of the review process, sending reminders to late reviewers, and recording information resulting from the reviews for discussion at the program committee meeting and to decide which papers should be accepted. To this end the reviews contain marks out of ten for originality, technical merit, relevance to this particular conference and an overall mark. When all reviews have been returned, the program committee meets and makes their decision as to which papers are to be selected. Letters are then sent, including the reviews, to authors of both the accepted and rejected papers. Then the final manuscripts for accepted papers start to arrive. The database is to be used to record problems such as missing copyright transfer forms, the paper being longer than allowed, formatting problems etc. Authors have to be contacted to correct any such papers and to hurry them along if they are late. Finally, the database is used to extract information for entry into the proceedings: table of contents (listing of papers, authors names) and a list of PCMs’ names for inclusion in the introduction of the proceedings.
    --------------------------------------------------------------------------

  4. #4
    Join Date
    Feb 2004
    Posts
    78
    i was also given UNF

  5. #5
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    Try to think about the model as one large table first.

    Then move into first normal form making sure to maintain inferred relationships.

    For example:

    UNF(Student, Course1, Instructor1, Course2, Instructor2)

    Student(Student(PK))
    Course(Course(PK),Instructor,Student(FK))

    The inferred relationship is student.

  6. #6
    Join Date
    Feb 2004
    Posts
    78

    no offence

    no offence but thats not rally much help.

    what does that mean in terms of my relationships?

  7. #7
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    Treat the UNF as one table. Then break it up preserving the inferred relationships.

    Paper(PaperID, AuthorID(FK), etc)
    Author(AuthorID, etc)

    I'm trying to help, but I'm not going to do your work.

    Here's an article on normalization

  8. #8
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    Last edited by certus; 02-14-05 at 11:49.

Posting Permissions

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