-
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
-
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
-
Forum Rules
|
|