This screencast is part of a playlist that summarizes why proper one-to-many relationships are essential for a healthy relational database and how those relationships work within a query. One-to-many and many-to-many relationships are reviewed, as well as the left and right outer joins between tables, and how those joins are used to find specific data in the database including orphan records. In addition, referential integrity is reviewed, and the SQL statements stored by select queries are examined.
All of my KZfaqs can be found at: learncs.w3spac...