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 25 -- Hoffer: Ch. 1

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

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

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

    Assignment 1 due Tuesday Sep 13th.

  5. Database Design: Physical Design and Access Methods -- Sep 20, 22 -- Hoffer: Ch. 6 & App. C

    Assignment 2 due Thursday 22nd.

  6. TBA -- Sep 27, 29 -- Hoffer: Ch. 7

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

  8. TBA -- Oct 11, 13 -- Hoffer: Ch. 10

  9. Database Security and Integrity & Database Administration -- Oct 18, 20 -- Hoffer: Ch. 10

  10. Object-Relational DBMS & JDBC -- Oct 25, 27 -- Hoffer: Ch. 12

  11. Data Warehouses and Data Mining -- Nov 1, 3 Hoffer: Ch. 9

  12. Data and Text Mining Applications -- Nov 8, 10

  13. XML and Databases -- Nov 13, 15 -- Hoffer: Ch: 11

  14. Future of DBMS - Next Generation Applications -- Nov 22

    • Slides from Lecture 21 download
    • November 24&25 -- Thanksgiving Holiday
  15. Wrapup : Class Project Demos -- Nov 29, Dec 1

  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.