Find courses with no required prerequisite.

Write queries/statements for the following. (Use tables created in Chapter 4 Lab Activity.)


```
SQL> SELECT *
2 FROM course
3 WHERE PreReq IS NULL;

COURSE TITLE CREDITS PREREQ
------ -------------------- ---------- ------
EN100 Basic English 0
CIS253 Database Systems 3
MA150 College Algebra 3
AC101 Accounting 3
```

Computer Science & Information Technology

You might also like to view...

In an SQL statement, a query parameter variable begins with the ____________.

a. param keyword b. var operator c. @ symbol d. ref clause

Computer Science & Information Technology

If you want to modify a saved query, open the query in ________ view

Fill in the blank(s) with correct word

Computer Science & Information Technology

In the figure above, the name of the book is Entrees.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

Given the following pseudocode, how many times will module B010 be called?

``` Start Process B000 DOWHILE not EOF Process B010 IF condition THEN Process B020 (ELSE) ENDIF ENDDO Process B020 Process B030 Stop ``` a) exactly 0 times b) 0 or more times c) exactly 1 time d) 1 or more times

Computer Science & Information Technology