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 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
- Spring '09
- data independence Entity-relationship, data independence Indexes, XML Schema Query, query performance Transactions