Topic 05, Part 08 - Implementing and using Recursive Relationships

preview_player
Показать описание
Dr. Soper describes how to implement and use recursive relationships in databases, including all of the SQL statements that are needed to perform recursive queries. This video is Part 08 of Topic 05 in Dr. Soper's class on Database Design and Management.
Рекомендации по теме
Комментарии
Автор

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.

youssefa
Автор

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?

mp_petrov
join shbcf.ru