Results 1 to 10 of 10
  1. #1
    Join Date
    Jun 2010
    Posts
    2

    Database Normalization

    Hey Guys, I need help on an ERD normalization question. from 1NF to 3NF?
    Hey I have two questions on normalization that I am practicing for my final but I cant seem to get them.
    This is in the 1st normal form and I need to get it to the 3rd normal form.
    1.
    Customer( CustomerID, Name, Address)
    Product(ProductID, Description)
    Order(Order Number, Customer ID, OrderDate)
    LineItem(OrderNumber, ProductID, OrderQuantity)
    Invoice(InvoiceNumber, OrderNumber, InvoiceDate)
    Shipment(InvoiceNumber,ProductID,Quant…

    2.
    Vendor(VendorID,Address)
    PriceOuote(QuoteQuantity,Price)
    Part(itemNumber, Description)
    PartReceipt(OrderNumber,Date,OrderQuan…

    I did them but I am not sure if they are correct.
    I need someone to help me get these to the 3rd NF from 1stNF.
    Thanks to all you guys out there.
    Any input is valued.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2010
    Posts
    2

    Cool Re: INFO

    Hey, thanks for the information posted.
    I read them and am still in the same place.
    i did the work already.
    I just need someone to do it so that I can check it with my work and see if I am on the right track.
    With the other example, they are kinda small ones, and this one is a big one. I just want to see if I am doing it correctly.
    Plz Help and Thanks

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    They look in 3NF already to me.

  5. #5
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Are they correct? Couldn't a customer have multiple addresses? Same with a vendor?
    Dave

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    PriceQuote looks incomplete, shouldn't it reference the item it is quoting a price for?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by dav1mo View Post
    Are they correct? Couldn't a customer have multiple addresses? Same with a vendor?
    Dave
    Perhaps, however that isn't normalisation but requirements.

  8. #8
    Join Date
    Aug 2010
    Location
    UK
    Posts
    1
    Hello Friends.......

    Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data and ensuring data dependencies make sense

    Thanks

  9. #9
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by alevin46 View Post
    There are two goals of the normalization process: eliminating redundant data and ensuring data dependencies make sense
    unfortunately this is wrong, eliminating redundant data is ~not~ a goal of normalization
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  10. #10
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    Quote Originally Posted by alevin46 View Post
    Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data and ensuring data dependencies make sense
    Normalization is a set of tools for analysing and eliminating certain types of redundancy. It cannot eliminate redundant data entirely. I doubt that any formal process ever could ensure non redundancy in all possible cases.

    No normalization procedure can ensure that the dependencies "make sense" because a set of (assumed to be correct) dependencies are a necessary input for normalization, not the product of it. Some dependencies may be eliminated by normalization but unfortunately that doesn't mean the set of dependencies at the end are the right ones to do the job the database was intended for

Tags for this Thread

Posting Permissions

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