Answer and Explanation:
select fname, lname, D.smaddr , AdivsorList.fname, AdivsorList.lname, AdivsorList.smaddr,
from PERSON P
left outer join DIGITAL D
ON P.idnum = D.idnum
left outer join
(SELECT P1.fname, P1.lname , A.idnum, D1.smaddr
from
ADVISOR A
left outer join Person P1
ON A.idnum = D1.idnum
left outer join DIGITAL D1
ON P1.idnum = D1.idnum
) as AdivsorList
ON P.idnum = AdivsorList.idnum