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 26, and will cover	

	Elmasri and Navethe, Chapters 7, 12 
	Course notes on bottom-up design
	Sunderraman Chapter 2

1.	Be able to write SQL queries (to the extent we have done this
	so far)

2.	Be able to write statement to create tables (including primary
	key and foreign key references)

3.	Be able to insert, delete, and modify records in tables.

4.	Be able to view a form and (following the process outlined in
	class) convert it to a series of tables in BCNF.

5.	Be able to define and discuss functional dependencies, 1NF, 2NF, 3NF 
	and BCNF.  Be able to identify violations of normalization (important
	note in class Monday), and show how these violations can be 
	corrected.