This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 1 Final Review CPS 116 Introduction to Database Systems 2 Announcements (Thu. Dec. 8) ¡ Homework #4 due today ¢ Sample solution available by email this weekend ¢ Will be graded by Tuesday ¡ Project demo next Monday-Wednesday ¢ You should have received emails confirming your demo slots ¢ Submit your report & code before demo ¡ Final exam Tuesday 2-4pm ¢ Open book, open notes; focus on the second half ¢ Similar format as sample final Announcements cont’d (Thu. Dec. 8) ¡ Handouts ¢ Lecture notes and assignments: course Web site ¢ Graded assignments and midterm, sample solutions/exams: handout box outside my office (LSRC D327) ¡ Check Blackboard to make sure we entered your scores correctly! 3 2 4 Review: relational basics ¡ Relational model/algebra ! physical data independence ¡ Entity-relationship design ¡ Design theory (FD’s, MVD’s, BCNF, 4NF) ! help eliminate redundancy ¡ SQL ¢ NULL and three-value logic ! nifty feature, big mess ¢ Bag versus set semantics ! careful about equivalences...
View Full Document
This document was uploaded on 01/17/2012.
- Spring '09