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 29, and will
cover
Date: Chapters 4, 9 - 11, Sunderraman,
chapter 2, SQL01.PPT, SQL02.PPT, DESIGN02.PPT
- Design
- Be able to define and explain functional dependencies, 1NF,
2NF, 3NF, BCNF. Be able to sketch a functional dependency diagram using
the diagram scheme discussed in class..
- Be able to identify violations of 2NF and 3NF and to
correct them.
- We will have a question on bottom-up design, but not on this
exam. Homework exercise on this coming soon.
- SQL
- Be able to write statements to create and drop tables,
views, and indexes.
- Be able to explain how views are implemented and the difference
between tables and views.
- Be able to write statements to insert, delete, and modify records in tables.
- Be able to describe the difference between DML and DDL
- Be able to use tuple variables to join a table with itself.
- Queries will be either with respect to the SPJ database, or to
the Hoh River College database.