In this recipe, we will use the SQL DELETE command to delete the data we created in the previous recipe, Using the SQL UPDATE command.
While deleting data might sound trivial at first, once we get a rather large database design in production, things might not be that easy any more.
Because we have designed our GUI database by relating two tables via a primary to foreign key relation, when we delete certain data, we do not end up with orphan records because this database design takes care of cascading deletes.