title: Employee Department Relationship in Database
body: <p>I'm designing a relational database for SCM (as part of designing information system for the enterprise). But when it came to the relationship between the employee and its department, I had some troubles .</p>
  
  <p>I designed the following entities : </p>
  
  <ul>
  <li><code>Employee</code> ( <strong>ID</strong> , Fname , Mname , Lname , Sex , Phone , Address , Hiring date , .. etc )</li>
  <li><code>Department</code> ( <strong>ID</strong> , name )</li>
  </ul>
  
  <p>and since the relation is one-to-many (every employee should work for - and only one - dept., while every dept has many employees), I added <code>Department ID</code> to the attributes of the <code>Employee</code>. But the problem is how to represent a <code>MANAGE</code> relationship (one-to-one).</p>
  
  <p>Is it valid to design a new relation that we call : <code>Employee_manage_Department</code> and its attributes are (<code>Employee ID , Department ID</code>) where both columns are part of the primary key ??</p>
  
  <p>thanks in advance</p>