Computer Science 455
Exam #2 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 second  hour exam will be on Friday, March 27,
and will cover
	Date, chapters  9, 10, 12, 
	Krohn  6,7
	
1.	Be able to construct an entity-relationship diagram from a 
	written description.  Be able to construct a relational 
	schema from an entity-relationship diagram, identifying
	primary and foreign keys.

2.	Be able to give definitions of functional dependency, candidate
	keys, first, second, third, and Boyce-Codd normal form.  Be 
	able to construct a relational schema from a form.  Be able to
	identify violations of first, second, and third normal form
	and to decompose a relation into equivalent relations that
	do not have these problems.

3.	Be able to describe the use of the database loader.  It will
	not be necessary to memorize database loader commands.

4.	Be able to outline the steps involved in creating a form 
	(including a master-detail form) from tables.  You will not
	be asked for specific key-sequences, but you should be able
	to convince me that you know how to do this (and have done
	this several times).  PLEASE NOTE:  Although you will
	not be asked for the keys necessary to enter and execute
	queries, etc., you SHOULD know the roles of the PF1,
	PF2, PF3, and PF4 keys, and the roles played by
	<cntrl>K and <cntrl>F.