Having trouble with an ERD relationship between an EMPLOYEE, MANAGER, & DEPARTARTMENT
Results 1 to 2 of 2

Thread: Having trouble with an ERD relationship between an EMPLOYEE, MANAGER, & DEPARTARTMENT

  1. #1
    Join Date
    Sep 2010
    Posts
    1

    Having trouble with an ERD relationship between an EMPLOYEE, MANAGER, & DEPARTARTMENT

    Hi,

    Let me start by saying I am new to database design. I have been programming for 5 years now but recently felt like it would be of worth to learn about databases and database design. I picked up a few books and am now working my way through them. So without further ado, hear is my first question.

    I am currently trying to understand and learn how to use the Entity Relationship Model. One of the books I am reading asks me to conceptualize a basic ERD showing the relationships between a Department, Employee, and Manager. The book offered me up these business rules….

    Each department has many employees, but each employee belongs to one department.

    Each department is managed by one employee, and each of those managers can manage only one department.



    So what I am confused about is if a manager is an employee how do I represent that relatiomship.

    Regards

    Chad

  2. #2
    Join Date
    Aug 2008
    Location
    Indiana
    Posts
    11
    Yes, I'm bumping a 7 year old thread. It wasn't, however, answered, and I'm curious as to how people would answer this....

    Brad!
    -------------------------------------------------------------
    Brad Jones
    Director, Developer.com Network
    Overseeing VBForums, Developer.com, CodeGuru, DevX, and more.
    (My recent articles)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •