Results 1 to 10 of 10

Thread: 3rd Normal Form

  1. #1
    Join Date
    Dec 2008
    Posts
    2

    3rd Normal Form

    How do I put these Tables in 3rd Normal Form? Thanks for your time

    PK = primary key, FK = Foreign Key

    tables
    VENDOR(Vendor_ID(PK), Address)
    PRICE QUOTE(Quote_Quantity(PK), Price)
    PART(Item_Number(PK), Description)
    PART RECEIPT(Order_Number(PK), Date, Order_Quantity(FK))

    Relations
    VENDOR 1:Many PRICE QUOTE
    PRICE QUOTE 1:Many PART RECEIPT
    PART 1:Many PRICE QUOTE

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    I dunno
    I tend not to think in terms of 1NF, 2NF, 3NF they are more aimed at learners int he db design pathway
    what did your teacher say?
    what do your fellow students & pupils say

    there are some excellent articles on normalisation, not least
    http://www.r937.com\Relational.html
    http://www.tonymarston.net/php-mysql...se-design.html

    ultimately what do you think
    do you think you have pushed your desing toe 3NF, as after all its your homework
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    I always find creating the tables and populating them with sample data a great way to spot potential areas for improvement...
    George
    Home | Blog

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    I find integers way too limiting, and prefer applying fractal dimensions to my databases. My preference is for a normalization level somewhere between 2.8 and 3.1.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    What's BCNF on that scale?
    George
    Home | Blog

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Quote Originally Posted by blindman
    I find integers way too limiting, and prefer applying fractal dimensions to my databases. My preference is for a normalization level somewhere between 2.8 and 3.1.
    i find the lack of precision totally uncool
    I try to achieve tolerance to two decimal places
    where's your sense of pride in your work
    where's that honesty in a good days work for a good days pay.....









    ...does this need a Mr Winky, or is it merely presumed
    I'd rather be riding on the Tiger 800 or the Norton

  7. #7
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    The normal forms for matter are solid, liquid, and gas. Plasma is arguable, but fun to play with!

    -PatP

  8. #8
    Join Date
    Dec 2008
    Posts
    2
    I appreciate the replies guys, I'm not a db expert. I was hoping that one of you might walk me through the process of coverting it to 3rd normal form ^_^

  9. #9
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    You should just have to add the relations to the tables, and they will be in 3rd normal form.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  10. #10
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by PoisonousFish
    I was hoping that one of you might walk me through the process of coverting it to 3rd normal form ^_^
    when is this assignment due?

    i could walk you through this some time late next week...
    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
  •