Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Note: Due to low reputation I can't post images so i have added the links accordingly.

I have this assignment I'm working and I am stuck in a recursive relationship, following is part of the case scenario that I am currently modelling;

http://i.stack.imgur.com/RsB8s.jpg

Now, from the first Three paragraphs i have deducted the following business rules;

  1. Employee is allocated ONE branch and a branch employs ONE or MANY employees
  2. Each branch is designated ONE manager and ONE assistant manager
  3. Employee is managed by ONE manager and supervised by ONE assistant manager
  4. Employee submits ZERO, ONE or MANY previous employment records, a instance of a record is associated to ONE employee only
  5. Employee is assigned ONE job position only, a job position can be assigned to ONE or MANY employees

(note: I have assumed in rule n.2 that a branch is also designated an assistant manager)

And now this is the ERD diagram for the above rules;

http://i.stack.imgur.com/aKaLb.png

So from the scenario, the assistant manager only supervises the staff, but it does not say that it has any relationship with the branch entity, however i assumed that a branch should have a relationship with the the manager and the assistant manager, but i am a bit confused so i havent added it yet to the erd diagram. Can you guys help me out?

share|improve this question
    
Is this homework? –  BryceAtNetwork23 Feb 13 '12 at 16:24
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.