title: Foreign Key issue SQL
body: <p>I cant figure out why this is not compiling It has to do with the foreign key somehow:</p>
  
  <pre><code>Drop Table Employee;
  Drop Table Department;
  
  
  Create Table Employee(
  EmpNr int not null primary key,
  EmpName Varchar(35) not null,
  Dept Varchar (2) not null,
  Gender char not null
  );
  
  Create Table Department(
  DeptCode Varchar (2) not null primary key,
  DeptName Varchar (35) not null,
  Foreign Key (DeptCode) references Employee (Dept)
  );
  
  insert into Employee values (001, 'HagarT','DV','M'),
                                 (002, 'WongS','DV','F'),
                                 (003, 'Jones','MK','F'), 
                                 (004, 'MifuneK','SL','M');
  
  insert into Department values ('DV',  'Development'), 
                                   ('MK', 'Marketing'), 
                                   ('RS',  'Research'),                               
                                   ('SL', 'Sales');
  </code></pre>