Get Spring 2003 course sections with the faculty member assigned to teach the class. Include course sections without any faculty assigned to them.
Use the Indo–US (IU) College database tables to design the following queries. (Use the spooling method to capture all queries and results in the CHAP7SP2.LST file)
```
SQL> SELECT COURSEID, SECTION, NAME
2 FROM FACULTY F, CRSSECTION C, TERM T
3 WHERE F.FACULTYID (+) = C.FACULTYID
4 AND C.TERMID = T.TERMID
5 AND UPPER(T.TERMDESC) = 'SPRING 2003';
COURSE SE NAME
--------- -- ---------------
CIS265 01
CIS265 02 JONES
LA123 05
CIS253 21 MOBLEY
CIS253 11 JONES
CIS253 31 MOBLEY
6 ROWS SELECTED.
```
You might also like to view...
Use __________ for the title of a book.?
A. ?italics B. ?quotation marks
When should you consider using a protocol analyzer?
What will be an ideal response?
The purpose of an operating system is to manage the flow of data between hardware components and allow the user to communicate with the computer.
Answer the following statement true (T) or false (F)
A gigabyte equals approximately 1 ______ bytes.
Fill in the blank(s) with the appropriate word(s).