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:
- Date: Chapters 10 - 12
- Sunderraman, chapter 2,
- WEEK05.PPT - WEEK09.PPT
Material
- SQL
- DML: Be able to write appropriate INSERT, DELETE, and UPDATE
statements
- DDL: Be able to create (and drop) tables (with constraints), create
and drop indexes, create and drop views. Be able to explain the
differences between tables and views.
- Bottom-up design: 1NF, 2NF, 3NF, BCNF
- Be able to define terms
- Be able to identify and resolve 2NF and 3NF problems
- Be able to identify BCNF problems