/* Join all 5 tables to validate successful create/load ###################################### */

SELECT c.course_id, c.description, cl.session_id, i.fname, i.lname, s.fname, s.lname, a.street1
from course c, class cl, instructor i, student s, address a
where c.course_id  = cl.course_id
  and i.ssn        = cl.inst_ssn
  and s.ssn        = cl.stu_ssn
  and s.student_id = a.stu_id
order by c.description, cl.session_id, s.lname