25-review-notes

25-review-notes - 1 Final Review CPS 116 Introduction to...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 3

25-review-notes - 1 Final Review CPS 116 Introduction to...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online