Display student names, their faculty advisors names, and faculty’s office location.
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 LAST || ', ' || FIRST STUDENT, NAME FACULTY, BUILDING, ROOMNO
2 FROM STUDENT S, FACULTY F, LOCATION L
3 WHERE S.FACULTYID = F.FACULTYID
4 AND F.ROOMID = L.ROOMID;
STUDENT FACULTY BUILDIN ROO
-------------------------------- --------------- ------- ---
DIAZ, JOSE MOBLEY GANDHI 101
TYLER, MICKEY CHANG GANDHI 105
PATEL, RAJESH JONES GANDHI 101
RICKLES, DEBORAH CHANG GANDHI 105
LEE, BRIAN SEN GANDHI 103
KHAN, AMIR WILLIAMS GANDHI 107
6 ROWS SELECTED.
```
You might also like to view...
Select all that apply. In the pseudocode of the textbook, which of the following are string functions?
a. isUpper b. toUpper c. stringToReal d. substring e. isDigit f. isInteger
The header of user-defined function empChange, passing emp1 as an output argument, would look like:
a. void empChange (emp1.emprec) b. void empChange (emprec*emp1) c. void empChange (emprec.emp1) d. void empChange (emprec&emp1) e. emp1 = void empChange ()
What command can you use to test the NIC's ability to send and receive packets?
A. arp-a B. ping 255.255.255.255 C. ping 127.0.0.1 D. ipconfig
?The main objective of all rapid application development (RAD) approaches is to extend development time and expense by excluding users from every phase of systems development.
Answer the following statement true (T) or false (F)