• A Few Database ER-Diagram Questions
    1 replies, posted
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.