RSS Forums RSS
Please support our Database Design advertiser: Programming Forums

3NF to BCNF?

•
•
Join Date: Feb 2007
Location: London
Posts: 114
Reputation: davidcairns is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 8
davidcairns davidcairns is offline Offline
Junior Poster

Re: 3NF to BCNF?

  #2  
Apr 3rd, 2007
I may be wrong but I believe the Employee Number field will be unique to and dependant on Warehouse, so remove Warehouse from that table and create a table of Employee Number and Part Number. Then make the key Part Number and Employee Number
Reply With Quote  
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 12:17 pm.
Newsletter Archive - Sitemap - Privacy Statement - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC