Is this the correct 0NF?

Reply

Join Date: Aug 2005
Posts: 8
Reputation: arya6000 is an unknown quantity at this point 
Solved Threads: 0
arya6000 arya6000 is offline Offline
Newbie Poster

Is this the correct 0NF?

 
0
  #1
Nov 26th, 2008
Hi

I'm in the learning process and I'm so sure if I did this one correctly, this is the User view


Department Product Aile Price Unit of Measure Supplier
code number

Produce 4081 1 0.35 Lb 32
Produce 4027 1 0.90 Ea 32
Produce 4108 1 1.99 Lb 21

Butcher 331100 5 1.50 Lb 08
Butcher 331105 5 2.40 Lb 08
Butcher 332110 5 5.00 Lb 08

Freezer 411100 6 1.00 Ea 10
Freezer 521101 6 1.00 Ea 10
Freezer 866503 6 5.00 Ea 45
Freezer 866504 6 5.00 Ea 45


so this is the UNF I got from it

UNF
DEPT[prodCode, (department, aileNum, measUnit, supplier)]


I have a feeling that its wrong, can you tell me what the correct one is?

Thank You
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Other Threads in the Database Design Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC