COMP 465: Databases, Spring 2014

Administrivia

Resources

Schedule

Date Topic Required Reading Notes Assignments Out Slides
1/9 Intro, data models all of chapter 1, 2.1     slides
1/14 The relational model, relational algebra 2.2, 2.4     slides
1/16 More relational algebra, just started SQL 2.4, 6.1      
1/21 SQL 6.1, 6.2      
1/23 SQL: Subqueries 6.3   Project Milestone 1, due in class on February 6.
Homework 1, due in class on January 30.
 
1/28 SQL: Aggregation and grouping 6.4      
1/30 SQL: Creating/updating tables, constraints 2.3, 6.5     slides
2/4 SQL: More constraints 2.5, 7.1-7.3   Homework 2, due in class on February 13. slides
2/6 E/R modeling 4.1     slides
2/11 E/R modeling II 4.1-4.3     slides
2/13 E/R modeling III 4.4, 4.5     slides
2/18 E/R modeling IV 4.5, 4.6   Project Milestone 2, due in class on March 4.
Homework 3, due in class on February 25.
slides
2/20 Linux, PostgreSQL, HTML, PHP        
2/25 PHP        
2/27 Midterm        
3/4 Programming        
3/6 (Prof out of town)        
3/18 Functional dependencies 3.1     slides
3/20 Functional dependencies 3.2     (see previous slides)
3/25 Normalization and BCNF 3.3     slides
3/27 3NF and multivalued dependencies 3.5, 3.6   Homework 4, due in class on April 8. slides
4/1 Wrapup multivalued dependencies and 4NF       (see normalization slides)
4/3 Indexes and B-trees 8.3, plus B-tree stuff (not in book) B-tree data structure and insertion algorithm
B-tree deletion algorithm
  slides
4/8 Query optimization/Views Query opt is not in the book; views is 8.1     slides
4/10 Transactions 6.6, plus slide material not in book   Homework 5, due in class on April 22. slides
4/15 XML        
4/22 XML        
4/24 Presentations and wrapup   XPath
XPath problems
Group project deliverables
Self/group evaluation
  slides