Andre Long

CISP 350 Oracle 9i

March 27, 2006

3CCase1a

SELECT term_desc, course_name, bldg_code, room
FROM term, course, location, faculty, course_section
WHERE course_section.course_id = course.course_id AND
course_section.term_id = term.term_id AND
course_section.f_id = faculty.f_id AND
course_section.loc_id = location.loc_id AND faculty.f_first='Kim' AND faculty.f_last='Cox';