title: ER Modelling - Subclass relationships & Relationship Entities
body: <p>I have a couple of specific questions regarding ER modelling.</p>
  
  <p>To provide some specific context, this is for a university project and I seem to not be able to hunt down specific answers to these questions. </p>
  
  <p><strong>Background</strong></p>
  
  <ul>
  <li>The ER model is depicting a small database for an accounting firm for them to manage their clients, their audit jobs (annual job), the time and fees for these jobs and a few other minor bits and pieces. The bits and pieces are silly (e.g. personal assistant typingSpeed, but are requirements for the project)</li>
  <li>Each client must have 1 audit completed every year and that audit is completed by 1 or more staff members who work at the accounting firm</li>
  <li>The client (and the audit job) are managed by a manager. Each client has only one manager who manages them and each manager can manage multiple clients</li>
  <li>As staff work on the audit, they charge time to the audit. The cost of the audit is calculated as their charge out rate multiplied by the total number of hours charged to the audit</li>
  <li>Each member of staff works for 1 and only 1 team. A team has 1 or more staff members working in it.</li>
  <li>A partner is a subclass of the staff superclass, with a unique rca number identifying them (accounting jargon). Each partner leads a team and each team has one and only one partner</li>
  <li>Each partner has a personal assistant and each personal assistant works for only 1 partner</li>
  </ul>
  
  <p><strong>ER Model</strong></p>
  
  <p><a href="https://i.stack.imgur.com/btLYf.png" rel="nofollow noreferrer">Audit Time &amp; Fee ER Model</a></p>
  
  <p><strong>Questions</strong></p>
  
  <ol>
  <li><p>Partner and Personal Assistant are both subclass entities and per my diagram there is a mandatory 1..1 relationship. Is it "legal" to have a specific relationship between subclasses? </p></li>
  <li><p>I have used an optional, or relationship for the subclasses of Staff, which I think is fine as a staff member cannot be any of the roles at the same time. The only omitted role as a subclass is that of "auditor". If I were to include this, would "optional, or" change to "mandatory, or", as all possible options are shown and the staff member must be one of those 4 roles?</p></li>
  <li><p>Between Annual_audit and Staff I have a relationship entity (I could be calling this something wrong there). Is this the correct way to show the relationship? I tried using a ternary relationship as well, but ended up going backwards and forwards several times. </p></li>
  <li><p>Any general feedback or pointing out of errors is most welcome</p></li>
  </ol>
  
  <p>Many thanks for any help anyone is able to provide.</p>