You'll learn what a primary key is, choose a primary key from table fields, and set relationships between tables. We will learn how to delete a relationship, understand the inner and outer join types, and understand what referential integrity means and how important it is to keep your database error-free. There is also a section on cascade updates, which are important when wanting any changes to be drilled down through the database design.
Defining the primary key, join type, and referential integrity
Defining primary keys
A primary key distinctively identifies each record (row) in the table. An example of a primary key is CustomerID—this would be a unique number for each customer. This is very similar to an ID...