Dr. Soper, thank you for this excellent video Your clear and thorough explanation, along with the detailed SQL statements, made the concept so much easier to understand.
In the example of representing 1:1 relationship @10:52, how is it possible that personId 3 is sponsoredById 5? Person 5 came later than person 3, so I would expect that personId is always a higher value than sponsoredById. That, of course, considering the PK column is following the DateTime of each record creation. Correct me if I am wrong?
Dr. Soper, thank you for this excellent video Your clear and thorough explanation, along with the detailed SQL statements, made the concept so much easier to understand.
In the example of representing 1:1 relationship @10:52, how is it possible that personId 3 is sponsoredById 5? Person 5 came later than person 3, so I would expect that personId is always a higher value than sponsoredById. That, of course, considering the PK column is following the DateTime of each record creation. Correct me if I am wrong?