Andre Long

CISP 350 Oracle 9i

March 28, 2006

3CCase1b

SELECT s_last, s_first, course_name, term_desc, grade
FROM student, course, term, enrollment, course_section, faculty
WHERE course_section.c_sec_id = enrollment.c_sec_id AND
enrollment.s_id = student.s_id AND
course_section.course_id = course.course_id AND
course_section.term_id = term.term_id AND
course_section.f_id = faculty.f_id AND
faculty.f_first='Kim' AND faculty.f_last='Cox';