title: Unable to delete a record due to foreign key restriction
body: <p>In my database, I have a table called "departments". It contains information about the individual departments. The "name" column of this table is declared as the <code>primary key</code>. </p>
  
  <p>Now one of my departments was removed. So I wish to remove that department record, and its related information, from my database. However, a <code>foreign key</code> restriction is preventing me from doing so. How can I resolve this problem?</p>