Please support our Database Design advertiser: Programming Forums
Views: 2315 | Replies: 1
 |
•
•
Join Date: Apr 2007
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
I've been trying to decompose this table that is already in 3NF into BCNF, no luck yet though, any ideas?
•
•
Join Date: Feb 2007
Location: London
Posts: 114
Reputation:
Rep Power: 2
Solved Threads: 8
Junior Poster
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
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
