If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Normalisation

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-21-08, 11:04
ACM ACM is offline
Registered User
 
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
Reply With Quote
  #2 (permalink)  
Old 11-21-08, 11:11
andrewst andrewst is offline
Moderator.
 
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?
__________________
Tony Andrews
http://tinyurl.com/tonyandrews
Reply With Quote
  #3 (permalink)  
Old 11-21-08, 11:52
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
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
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #4 (permalink)  
Old 11-21-08, 12:19
ACM ACM is offline
Registered User
 
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.
Reply With Quote
  #5 (permalink)  
Old 11-21-08, 12:30
andrewst andrewst is offline
Moderator.
 
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!
__________________
Tony Andrews
http://tinyurl.com/tonyandrews
Reply With Quote
  #6 (permalink)  
Old 11-21-08, 12:44
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
and not just here, either

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On