Oracle3C_Complete_Chen_Jason

Oracle3C_Complete_Chen_Jason - - BMIS441 SQL> - JASON...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
-- BMIS441 SQL> -- JASON CHEN, ROW: 1 SQL> -- FILE NAME: 3CCASE1.SQL SQL> -- 1a. SQL> SQL> SELECT term_desc, course_name, bldg_code, room 2 FROM faculty, location, course_section, term, course 3 WHERE faculty.f_id = course_section.f_id 4 AND location.loc_id = course_section.loc_id 5 AND term.term_id = course_section.term_id 6 AND course.course_id = course_section.course_id 7 And f_last = 'Cox' 8 AND f_first = 'Kim'; TERM_DESC COURSE_NAME BLDG_CODE ROOM -------------------- ------------------------- ---------- ------ Spring 2007 Database Management BUS 105 Spring 2007 Database Management BUS 105 Summer 2007 Intro. to Info. Systems CR 101 SQL> SQL> -- 1b. SQL> column s_last format a9 SQL> column s_first format a9 SQL> Column course_name format a24 SQL> Column term_desc format a12 SQL> column time format a15 SQL> SQL> SELECT s_last, s_first, course_name, term_desc, grade 2 FROM faculty, enrollment, course_section, term, course, student FACULTY f_last (search) f_first (search) f_id (join) COURSE_SECTION f_id (join) loc_id (join) term_id (join) course_id (join) LOCATION loc_id (join) bldg_code (display) room (display) TERM term_desc (display) term_id (join) COURSE course_name (display) course_id (join) FACULTY F_last (search) F_first (search) F_id (join) COURSE_SECTION F_id (join) Term_id (join) Course_id (join) C_sec_id (join) ENROLLMENT C_SEC_ID (join) s_id (join) Grade (display) TERM Term_desc (display) Term_id (join) COURSE Course_name (display) Course_id (join) STUDENT S_first (display) S_last (display) S_id (join)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
3 WHERE faculty.f_id = course_section.f_id 4 AND course_section.c_sec_id = enrollment.c_sec_id 5 AND term.term_id = course_section.term_id 6 AND course.course_id = course_section.course_id 7 AND enrollment.s_id = student.s_id 8 And f_last = 'Cox' 9 AND f_first = 'Kim'; S_LAST S_FIRST COURSE_NAME TERM_DESC G --------- --------- ------------------------ ------------ - Miller Sarah Database Management Spring 2007 B Umato Brian Database Management Spring 2007 A Mobley Amanda Intro. to Info. Systems Summer 2007 Sanchez Ruben Intro. to Info. Systems Summer 2007 Connoly Michael Intro. to Info. Systems Summer 2007 SQL> -- BMIS441 SQL> -- JASON CHEN, ROW: 1 SQL> -- FILE NAME: 3CCASE2.SQL
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/26/2010 for the course ITS 26 taught by Professor Jack during the Spring '10 term at Staten Island.

Page1 / 6

Oracle3C_Complete_Chen_Jason - - BMIS441 SQL> - JASON...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online