Results 1 to 6 of 6

Thread: Normalisation

  1. #1
    Join Date
    Nov 2008
    Posts
    2

    Normalisation

    I've been given the UNF for this complaints database I'm making. I'm wondering if anybody could tell me the 1NF, 2NF and 3NF for the below data?

    UNF:

    Complaint Details

    Complaint_ID*
    Product_Malfunction
    Rude_Staff
    Late_Delivery
    Overcharging
    Department
    Complaint_Date
    Resolve_Date/Progress

    Customer Details

    Customer_Name
    Customer_Surname
    Customer_Address
    Customer_Phone

    Product Details

    Product_Name
    Product_Code
    Product_Store
    Product_Quantity

    Store Details

    Store_Name
    Store_Address
    Store_Manager
    Store_Phone

    Manufacturer Details

    Manufacturer_Name
    Manufacturer_Address
    Manufacturer_Phone
    Loyalty_Card

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    It all looks pretty normalised already. The only odd thing is that none of the tables appear to be related in any way. Shouldn't Products be related to Manufacturers, Complaints to Customers? i.e. by foreign key columns?

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    the following is a violation of the spirit, if not the letter, of first normal form:

    Rude_Staff
    Late_Delivery
    Overcharging

    these are all different types of complaint; you've got them as attributes (boolean?) of the complaint itself
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Nov 2008
    Posts
    2
    Well what I was given was the UNF for the data. There maybe one or two errors when I copied it down. But could anybody put the information there into 1NF, 2NF and 3NF? Correct one or two things if you have to.

  5. #5
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    One fears that one would be doing someone else's homework for them, which is considered bad form here!

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    and not just here, either

    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
  •