Computer Science 455
Exam #3 Review

Disclaimer:  I have attempted to be comprehensive in the 
	following, but important items may have been 
	omitted by mistake.  If you see such an omission,
	please let me know, but you are responsible for
	all of the lecture material to date.


The third  hour exam will be on Friday, April 24,
and will cover

	Date, chapters 6 and 8 
	Krohn  chapters on SQL*Report, SQL*Menu, and PL/SQL
	Relational Algebra handouts
	
1.	Be able to describe how reports are constructed using SQL*Report
	and how menus are constructed using SQL*Menu

2.	Be able to write basic triggers using PL/SQL.  You may be asked
	to write a trigger in PL/SQL.

3.	Be able to describe how embedded SQL works in a C
	program.  You may be asked to write some simple code
	using embedded C.

4.	Be  able to describe cursors, demonstrate how
	they are used, and describe the problem that they solve.


5.	Be able to write advanced SQL queries  using, for example,
		Tuple variables
		Aggregation
		Group by
		Having
		Subqueries
		IN, = ANY, etc.
		EXISTS/NOT EXISTS (including ñforallî queries)
		Outer Joins and other queries using null values 
			(be able to explain outer joins and null values)
		Relational algebra operations in SQL 

5.	Be able to write queries using the full relational algebra (including
		ñforallî queries using DIVIDEBY).  Relational calculus
		queries wonÍt appear until the final exam.

6.	Be able to explain the role of a data dictionary in a relational database,
	illustrating your discussion by referring to the elements of the data
	dictionary in Oracle (as discussed in class and in the notes).
		
Queries will be with respect to the SPJ database and also (perhaps!) with respect to
the following (Hoh River College) database:

	STUDENT(SNO, SNAME, MAJOR, ADVISOR)
		(ADVISOR is the FNO value of the studentês advisor)
	FACULTY(FNO, FNAME, DEPT)
	CLASS(CNO, CNAME)
	TEACH(FNO, CNO)
	ENROLL(SNO, CNO, GRADE)