SQL-4a - Referential Integrity and MySQL Safe Update Mode and Syntax Descriptions

Before we get into deeper concepts about data, let's review some critical terms and concepts including how DBMS's ensure our data is in sync and has no "orphan" data. Let's also understand how MySQL provides "training wheels" to ensure we aren't using our UPDATE and DELETE as "weapons of mass destruction" on our table data. We'll also dig deeper into syntax description notation, so as we get to more intricate syntax we'll be ready.