LOCATION LOC ID BLDG CODE OOM CAPACITY TERM TERMJD | TERM-DESC | STATUS | START-DATE C SEC D GRADE Nomber Number Number 101 150 Fall 2006 CLOSED28-AUG-07 2007 CLOSED09-IAN-08 Summer 2007 CLOSED 1SMAY-06 CLOSED28-AUG-0 2019 OPEN 08-IAN-08 Fall 2007 Fall 2018 OPEN 07-MAY-08 COURSE NAME CREDITS Number 3 NO Intro. to Info. Tech Systems Analysis S 301 IT 240 CS 120 T 451 12 Intro. To Web-Based STUDENT FIRST ISM IS ADDRESS 1817 951 Rainbow Drive 275 W Main St 428 EN 16 Street Circle HoustonT Abilene T lsT AbileneT AbileneTK Pt WorthT ones 77027 13 MarshJohn Smith Mike ohnsonL 79901 78767 M 688 4 Street COURSE SECTION STUDENT SPHONE S CLASS 250987654 SR ATE ENROLLED 0.00 AM1050AM 045 4M #50AM 00AM 1215AM Date/Time 07/14/85 891 1 08/19/861230 1 1010/83 5131 24/871841 30 AM 58765432 S 5765432 R 256543210 S0 355432109 SO 254321098F 06/03/03 01/10/02 08/24/03 08/23/04 01/08/05 08/22/06 200 50 AM 1050AM 15 AM S0 PM 30 PM #30AM 30AM 30 AM 0.00 AM 200 PM 00 PM FACULTY FLAST IF FIRST IF Mi ID IF-PHONE | FRANK IF Teresa J huin MarkM 3251234567 Associate 4 252345678 Ful 3253456789 Assistant 4 3254567390 Full 3255578901 Associate 2 1121 Brown JonneD 297 ames h. For each student, list the student ID, student last name, student first name, faculty ID, and faculty last name . List the last names of faculty who are teaching in the Summer 2008 term. e. Create a Union query that displays the names of courses taken by students who were not Seniors, in addition to courses that were offered in Term 6 f Use the Intersect set operator to create a query that satisfies both requirements of Question (e)