UC Berkeley School of Information

IS 257: Database Management

Outline and Schedule

This is a preliminary outline for the course. It is expected to change during the semester.

(Week. Content -- dates -- readings)

  1. Introduction to database concepts & Data Models -- Aug 26 -- Hoffer: Ch. 1

  2. Database planning and Conceptual Design -- Aug 31, Sep 2 -- Hoffer: Ch. 2 & 3 & 14

  3. Organizing Information into a Database (logical database design) & Normalization --
    Sep 7, 9 -- Hoffer: Ch. 4 & 5

    Assignment 1 due Thursday 9th.

  4. Relational DBMS & Relational Algebra and Calculus : Introduction to SQL -- Sep 14, 16 -- Hoffer: Ch. 7 & App. C

  5. MySQL -- Sep 21, 23 -- Hoffer: Ch. 7

    • Tuesday: Kevin Heard on Using MySQL
    • Thursday: No Class - workshop
  6. Database Design: Physical Design and Access Methods -- Sep 28, 30 -- Hoffer: Ch. 6 & App. C

    Assignment 2 due Tuesday 28th.

  7. More on MySQL & Database Applications & PHP -- Oct 5, 7 -- Hoffer: Ch. 8

  8. Database Security and Integrity & Database Administration -- Oct 12, 14 -- Hoffer: Ch. 10

  9. Object-Relational DBMS & JDBC -- Oct 19, 21 -- Hoffer: Ch. 12

  10. Data Warehouses and Data Mining -- Oct 26, Oct 28 Hoffer: Ch. 9

  11. Data and Text Mining Applications -- Nov 2, 4

  12. XML and Databases -- Nov 9, 11 -- Hoffer: Ch: 11

  13. XML, The Grid/Cloud and Next Generation Applications -- Nov 16, 18 -- Hoffer: Ch. 13 & 15 & Appendix D.

  14. Future of DBMS -- Nov 23

    • Slides from Lecture 23 download
    • November 25&26 -- Thanksgiving Holiday
  15. Wrapup : Class Project Demos -- Nov 30, Dec 2

  16. RRR Week -- Dec 7, 9

    • RRR Period - no lectures
  17. Final Project Papers Due -- Dec 13

    • Dec 13 RRR Period ends - Final final project papers due.