•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 397,816 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,575 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser:
Views: 2005 | 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)
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
Hybrid Mode
- learning php (PHP)
- 3nf database again (Computer Science and Software Design)
- 3nf database (Computer Science and Software Design)
- 3nf (Database Design)
- can you help - access (MS Access and FileMaker Pro)
- Problem with Rewriting Subqueries as Joins (MS SQL)
Other Threads in the Database Design Forum
- Previous Thread: Built an ER-Model
- Next Thread: Storing if a user has viewed a post
