There's a few parts that have been stumping me on my assignment. Here are some of the notes provided in the question:
-a bank with multiple branches
-each branch has 1 manager, each manager manages only 1 branch
-branches have non-managerial employees, but these employees can work at multiple branches
so basically.. I had a M:N with branches/non-managerial employees, but I know you're supposed to split M:N's into two 1:M's, which led me to this
Branch 1 -- M Employs M -- 1 Non-Managerial Employees
(I think this is right, but I'm not 100% positive) So now the question is can I just stick Manager into Employs? Would it be a 1:1? Also when converting into tables, would the composite key for Employs be the Primary keys of Branch, Non-Managerial Employees AND Managers?
Thx for any of your help!
Fast Threads is a better place for this.
[URL]http://www.facepunch.com/forumdisplay.php?f=60[/URL]
Sorry, you need to Log In to post a reply to this thread.