Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2010

    ERD Diagram help


    I'm new to database and have been working on an erd diagram and have confused myself from working on it for so long. It's a basic estate agent database. Basically a branch has properties for rent and for sale where each property is exclusive to one branch only. I've only worked on the properties getting sold so far by the way.

    My main concern is whether I've got the relationships correct for the manager aspect or should it be included some how in the employer table?

    My reason behind the relationships are:
    Each branch should only have one main branch manager and only one manager can manage a single branch.
    Each department(Rentals,Selling etc) would only have one manager and resulting head of all staff under that department.

    Is my logic correct?

    Last edited by monkeyhead89; 11-27-10 at 07:22.

Posting Permissions

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