For use in on homeworks and on the project, you will be given an account (if you don't already have one) on the CSEPCLAB WindowsNT domain.

There are five homework assignments. The assignments and solutions will become available here at the appropriate times. Solutions will be available at most one week after the due date of an assignment, but usually much sooner.

We expect your answers to be precise, concise, and to reflect clear and thorough thinking. Make any reasonable assumptions you need to on the homeworks, but state them clearly. The TA and I decide if an assumption is reasonable, so if you're not sure, ask one of us! Homework assignments will be graded by the TA and reviewed by me.

Assignment | Topic | Date Assigned | Date Due | Solutions |
---|---|---|---|---|

Homework 1 | E/R Diagrams and Relations | January 5 | January 14 | Solutions in postscript and pdf |

Homework 2 | Normalization and Relational Algebra | January 14 | January 28 | HW2 solutions in postscript and pdf |

Homework 3 | SQL | January 28 | February 4 | HW3 solutions in postscript and pdf |

Homework 4 | Indices and Query Processing | February 9 | February 18 | HW4 solutions in postscript and pdf |

Homework 5 | Concurrency Control and Recovery | February 23 | March 3 | HW5 solutions in postscript and pdf |