title: Employee, Departments, and ManagerID Table Structures
body: <p>In MS SQL, I have employees and departments tables. I need remodel the tables to allow me to assign department managers. </p>
  
  <p><strong>Here are the existing tables:</strong></p>
  
  <pre><code>Employee 
  ---------
  emp_id
  emp_name 
  emp_email
  Dept_id
  
  
  Departments 
  -----------
  Dept_id
  Dept_name
  </code></pre>
  
  <p>The rules I have are as follows:</p>
  
  <ul>
  <li>A dept manager is an existing employee who is already in the emp
  table.</li>
  <li>Employee can only be assigned to one department.</li>
  <li>A department may not have a manager.</li>
  </ul>
  
  <p>What new fields and constraints do I need to add? </p>
  
  <p>Knowing that a manager is an employee as I indicated.
  What SQL Query can I use to list department name, managers-name, manager-extension,manager-email for all departments with a manager assigned?</p>
  
  <p>Thanks</p>