Results 1 to 2 of 2

Thread: Normalisation

  1. #1
    Join Date
    Nov 2008
    Posts
    1

    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
    Dec 2008
    Posts
    10

    Normalized to HNF

    Have a look at this.

    Complain Database.GIF

Posting Permissions

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