SIMS 257 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, 29) -- Hoffer: Ch. 1 
    Slides from Lecture 1 [download]
    Slides from Lecture 2 [download]
  2. Database planning and Conceptual Design (Sep 3, 5)  -- Hoffer: Ch. 2 & 3 & 14 
    Slides from Lecture 3 [download]
    Slides from Lecture 4 [download]
  3. Organizing Information into a Database (logical database design) & Normalization (Sep 10, 12) -- Hoffer: Ch. 4 & 5 
    Slides from Lecture 5 [download]
  4. Guest Lecturers -- (Sep 17, 19)
    Sep 17: Marti Hearst on Flamenco.
    Sep 19: Exercise on ER Modeling   Sample Solution
  5. Guest Lecturers -- (Sep 24, 26)
    Sep 24: Mark Butler, Interwoven
    Sep 26: Avi Rappoport, Search.com
  6. Physical data organization and access methods & Integrity Constraints (Oct 1, 3)-- Hoffer: Ch. 6
    Slides from Lecture 7 [download]
    Slides from Lecture 8 [download]
  7. Relational DBMS & Relational Algebra and Calculus (Oct 8, 10) -- Hoffer: Ch. 7
    Slides from Lecture 9 [download]
    Slides from Lecture 10 [download]
  8. More on SQL and Database Applications(Oct 15, 17)-- Hoffer: Ch. 8 
    Slides from Lecture 11 [download]
    Slides from Lecture 12 [download] -->
  9. Database and Web Applications (Oct 22, 24) --Hoffer: Ch. 9  
    Slides from Lecture 13 [download]
    Slides from Lecture 14 [download]
  10. More on Web Applications & 4GLs and Object Relation extensions to SQL (Oct 29, 31) -- Hoffer Ch. 10 
    Slides from Lecture 15 [download]
    Slides from Lecture 16 [download]
    Converting to Oracle Handout
  11. Database Administration & Database Applications (Nov 5, 7) -- Hoffer: Ch. 12
    Slides from Lecture 17 [download]
    Slides from Lecture 18 [download]
  12. Data Warehousing and Data Mining (Nov 12, 14) -- Hoffer: Ch: 11 
    Slides from Lecture 19 [download]
    Slides from Lecture 20 [download]
  13. Object Oriented Data Model  & Object-Relational DBMS & Applications (Nov 19, 21) -- Hoffer: Ch. 13 & 15 & Appendix D. 
    Slides from Lecture 21 [download]
    Slides from Lecture 22 [download]
  14. Future of DBMS (Nov 26, 28)(Nov. 28 is Thanksging holiday) 
  15. Class Project Demos & Wrapup ( Dec 3, 5)