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 29, Aug 32 -- Hoffer: Ch. 1

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

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

  4. Design Workshop/Lab Sessions -- Sep 19, 21 -- Hoffer: Ch. 4 & 5

    • Ray will be gone this week. Yuri will lead a workshop (during regular class hours), looking at specific database design cases, which should help you with Assignment 2.

    • The slides from the Tuesday workshop are available as either pdf or odp. You can also get the diagram that we created today. Please keep in mind that the diagram is incomplete (as was mentioned in class). The slides are similarly not meant to be used by themselves.

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

  6. Relational DBMS & Relational Algebra and Calculus : Introduction to SQL -- Oct 3, 6 -- Hoffer: Ch. 7

  7. Introduction to ORACLE & Database Applications -- Oct 10, 12 -- Hoffer: Ch. 8

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

  9. Database Security and Integrity & Database Administration -- Oct 24, 26 -- Hoffer: Ch. 12

  10. Object-Relational DBMS & JDBC for Java Applications -- Oct 31, Nov 2 Hoffer: Ch. 9

  11. Database Toolkits and Alternative Interfaces -- Nov 7, 9

    • _ Nov 9 -- Presentation by Yuri_
  12. Data Warehousing and Data Mining -- Nov 14, 16 -- Hoffer: Ch: 11

  13. TBA -- Nov 21, 23 -- Hoffer: Ch. 13 & 15 & Appendix D.

    • Slides from Lecture 21 download
    • Nov 23 -- Thanksgiving Holiday
  14. Future of DBMS -- Nov 28, 30

  15. Wrapup : Class Project Demos -- Dec 5, 7