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

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

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

  4. Database Design: Physical Design and Access Methods -- Sep 15, 17 -- Hoffer: Ch. 6 & App. C

  5. Relational DBMS & Relational Algebra and Calculus : Introduction to SQL -- Sep 22, 24 -- Hoffer: Ch. 7

  6. MySQL -- Sept 29, Oct 1 -- Hoffer: Ch. 7

    • Tuesday: Kevin Heard on Using MySQL
    • Thursday: No Class - workshop
  7. More on MySQL & Database Applications -- Oct 6, 8 -- Hoffer: Ch. 8

  8. Database Applications: Coldfusion and PHP & More on SQL & MySQL -- Oct 13, 15 -- Hoffer: Ch. 10

  9. Database Security and Integrity & Database Administration -- Oct 20, 22 -- Hoffer: Ch. 12

  10. Object-Relational DBMS -- Oct 27, Oct 29 Hoffer: Ch. 9

  11. JDBC for Java Applications & Data Warehouses -- Nov 3, 5

  12. Data Warehousing and Data Mining -- Nov 10, 12 -- Hoffer: Ch: 11

    • No class on Tuesday
    • Slides from Lecture 19 download
  13. Data and Text Mining Applications -- Nov 17, 19 -- Hoffer: Ch. 13 & 15 & Appendix D.

  14. Future of DBMS -- Nov 24

    • Slides from Lecture 22 download
    • November 26&27 -- Thanksgiving Holiday
  15. Wrapup : Class Project Demos -- Dec 1, 3

  16. Final Projects Due -- Dec 8

    • Dec 8 RRR Period - no lecture: Final final project papers due.