Create a SQL script file that will

a) Create a view that will display the names of courses taught by Anita Morris
b) Display that data from the view.

You should be able to run the script from the SQL*Plus command line with the @ symbol or the "run" command


```
CREATE OR REPLACE VIEW v_morris AS
SELECT course_no, description
FROM course c
WHERE EXISTS (SELECT null
FROM section s, instructor i
WHERE s.instructor_id = i.instructor_id
AND c.course_no = s.course_no
AND last_name = 'Morris'
AND first_name = 'Anita')

SELECT *
FROM v_morris
```

Computer Science & Information Technology

You might also like to view...

Disk mirroring is a method of storing data that generates extra bits of data from existing data, allowing the system to create a "reconstruction map" so that if a hard drive fails, it can rebuild lost data.

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

Computer Science & Information Technology

Is the following string a prefix expression? +–/ abc * + def *gh

What will be an ideal response?

Computer Science & Information Technology

Each category of data is stored in a database ____________________.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

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

a) By convention, method names begin with an uppercase first letter, and all subsequent words in the name begin with a capital first letter. b) An import declaration is not required when one class in a package uses another in the same package. c) Empty parentheses following a method name in a method declaration indicate that the method does not require any parameters to perform its task. d) A primitive-type variable can be used to invoke a method. e) Variables declared in the body of a particular method are known as instance variables and can be used in all methods of the class.

Computer Science & Information Technology