Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2014
    Posts
    3

    Question Unanswered: Help with 1nf,2nf,3nf ?

    Im just starting out with databases - Im okay with the sql side of things..
    I have this table that i have a hard time with Normalization..
    Any help would be appreciated

  2. #2
    Join Date
    Jun 2014
    Posts
    3

    Question Help with 1nf,2nf,3nf ?

    Im just starting out with databases

    Im okay with the sql side of things..
    I have this table that i have a hard time with Normalization..
    Any help would be appreciated
    Attached Thumbnails Attached Thumbnails Untitled-1.jpg  
    Last edited by Aq76; 06-02-14 at 00:23. Reason: Picture wasn't uploaded

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    So what have you tried
    where are you up to
    what are you stuck on

    BTW like most people on this forum I wont 'do' homework..
    theres plenty of good resources on normalisation on t'web
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Jun 2014
    Posts
    3
    Heres what im upto in 1NF ~ Does that seem in the right track

    ProjNo
    Project Name

    Emp No
    Employee Name
    Team Leader

    Charge/Hour
    Job Class
    Hours Billed

    Total Charge
    Subtotal
    Total

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I STRONGLY recommend the Marc Rettig Normalization Poster whenever people have basic questions about normalization or the process used to convert a data-pile into the Nth Normal Form.

    This poster is the most succinct and digestible presentation on Normalization that I've found so far, but people tend to underestimate the time and effort needed to absorb what they need/can from the poster. Spend a little time (like an hour or three) with it and Normalization up to 5NF (the fifth normal form) will be a straightforward process for you, and 5NF is further than almost any data needs to be normalized.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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