Display course titles along with their prerequisite names. Display courses without prerequisite also.
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 C.TITLE COURSE, P.TITLE PREREQ
2 FROM COURSE C, COURSE P
3 WHERE C.PREREQ = P.COURSEID (+);
COURSE PREREQ
--------------------------- --------------------
BASIC ENGLISH
ENGLISH LITERATURE BASIC ENGLISH
DATABASE SYSTEMS
SYSTEMS ANALYSIS DATABASE SYSTEMS
COLLEGE ALGEBRA
ACCOUNTING
6 ROWS SELECTED.
```
You might also like to view...
Which of the following are the classes in JavaFX for representing an event?
a. ActionEvent b. MouseEvent c. KeyEvent d. WindowEvent
The contents of the CPU cache and registers get erased every time the computer gets turned off
Indicate whether the statement is true or false
Prove that if a schema, S =(S, F), is in 3NF, then every FD in F + (not only those that are in F) satis?es the 3NF requirements.
What will be an ideal response?
To move a file between folders on two different disk drives, you will need to ____________________-drag a file.
Fill in the blank(s) with the appropriate word(s).