| Class number | Date | Reading due | Homework due
at the beginning of class |
Class content |
| 1 | Jan 8 | Data abstraction | ||
| 2 | Jan 10 | |||
| 3 | Jan 15 | E&N, Chaps 1-3 | email records | Class canceled |
| 4. | Jan 17 (MLK follows) | E&N, Chap 5 | Files | |
| 5 | Jan 22 | E&N, Chap 6 | Disk files | |
| 6 | Jan 24 | Read Chap 5 exercises to understand issues. | Indexes | |
| 7 | Jan 29 | Chapter 4 exercises | Class canceled | |
| 8 | Jan 31 | b-trees | ||
| 9 | Feb 5 | b-trees | ||
| 10 | Feb 7 | ER diagrams | ||
| 11 | Feb 12 | File search programs | ER diagrams | |
| 12 | Feb 14 | Chap 3, 7, Appendix C and D | Chapter 6 exercises | Legacy DBMS systems: hierarchical,
network |
| 13 | Feb 19 | Relational model | ||
| 14 | Feb 21 | Chap 7, 9.1 | Project proposal | Select, project, join |
| 15 | Feb 26 | More join, union, intersection and diff. | ||
| 16 | Feb 28 | Exam 1 | ||
| 17 | Mar 5 | Introduction to Access | ||
| 18 | Mar 7 (break follows) | Chap 8, 10 | ER -> relation homework | More Access |
| 19 | Mar 19 | Relational dependency | ||
| 20 | Mar 21 | Chap 14 | Normal forms | |
| 21 | Mar 26 | Normal forms | ||
| 22 | Mar 28 (holiday follows) | Chap 16 (general) | Hedlund: case study | |
| 23 | Apr 2 | Chap 14 homework | Transaction processing | |
| 24 | Apr 4 | Chaps 19-21 | Simultaneous transactions | |
| 25 | Apr 9 | Project proposal | ||
| 26 | Apr 11 | Exam 2 | ||
| 27 | Apr 16 | |||
| 28 | Apr 18 | |||
| 29 | Apr 23 | Projects due | Project presentations | |
| 30 | Apr 25 | Project presentations | ||
| 31 | Apr 30 | Review and final preview | ||
| Final exam | Saturday, May 4 | 9:00am - noon |
Homework Please
turn in written homework on 8 1/2 x
11 paper, unfolded, and stapled in the
upper left corner. If you turn in larger paper, I reserve the right
to trim it to 8 1/2 x
11
and grade what's left.
Exams Exams will be closed book, notes, etc.
Final exam Content:
the entire course, but with slight emphasis on material not previously
examined.
Format: closed books, notes, etc. The exam will
be designed
for about 150 minutes, but you will have the full 180 minutes.
Course grades Course
grades will be turned in to the Registrar's office within 72 hours of the
end of the final exam. The Registrar will post the grades to the
web where you
can see them. The Department of Computer Science will not give out
grades.