title: Converting a relation into 3NF
body: <p>The given FDs are - </p>
  
  <pre><code>Epmployee#→Dept#,Manager# 
  Dept#→Manager# 
  course#→course_title
  </code></pre>
  
  <p>The table is-<a href="https://i.stack.imgur.com/O8DWZ.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/O8DWZ.jpg" alt="enter image description here"></a><br> I have decomposed it into 3 relations. They are in 3NF. </p>
  
  <pre><code>R1 (Employee#, Dept#)  --- Employee is PK
  R2 (Employee#, Course#, course_title, date)  --- Emp# and Course# are PK
  R3 (Dept#, Manager#) --- Dept# is PK
  </code></pre>
  
  <p>The Primary Keys are as above.<br> However, when I inserting the data into R2, I get a primary key conflict. It is in red. <a href="https://i.stack.imgur.com/Rc1tq.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Rc1tq.jpg" alt="enter image description here"></a> Where am I going wrong? Any help would be really appreciated.  </p>