SIMS 257 Outline and Schedule

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

Week. Content (dates) -- readings

  1. Introduction to database concepts ( Aug 28, 30) -- Riccardi: Ch. 1 
    Slides from Lecture 1 [download]
    Slides from Lecture 2 [download]
  2. Data Models - Relational, Network, Hierarchic, Object, Object-Relational(Sep 4, Sep 6)  -- Riccardi: Ch. 2 
    Slides from Lecture 3 [download]
    Slides from Lecture 4 [download]
  3. Database planning and Conceptual Design (Sep 13) No Class Meeting Sept. 11 -- Riccardi: Ch. 3 
  4. Conceptual Design & Organizing Information into a Database (logical database design); Normalization (Sep 18, 20)-- Riccardi: Ch. 4 
    Slides from Lecture 5 [download]
    Slides from Lecture 6 [download]
  5. Physical data organization and access methods -- Integrity Constraints(Sep 25, 27) -- Riccardi: Ch. 11
    Slides from Lecture 7 [download]
    Slides from Lecture 8 [download]
  6. Relational DBMS & SQL - Relational Algebra and Calculus(Oct 2, 4) -- Riccardi: Ch. 6 & 7 
    Slides from Lecture 9 [download]
    Slides from Lecture 10 [download]
  7. Database Applications (Oct 9, 11) --Riccardi: Ch. 8 & 9 
    Slides from Lecture 11 [download]
    Slides from Lecture 12 [download]
  8. Database and Web Applications & More on SQL (Oct 16, 18) -- 
    Slides from Lecture 13 [download]
    Slides from Lecture 14 [download]
    Converting to Oracle Handout
  9. Query and Data Manipulation Languages -- 4GLs & Database Administration (Oct 23, 25)
    Slides from Lecture 15 [download]
    Slides from Lecture 16 [download]
  10. Data Warehousing and Data Mining (Oct 30, Nov 1) -- 
    Slides from Lecture 17 [download]
    Slides from Lecture 18 [download]
  11. Guest Lecturers -- (Nov 6, 8)
  12. Object Oriented Data Model and Other Database Systems (Flat, inverted files, etc.) & Object-Relational DBMS & Applications(Nov 13, 15) -- Riccardi: Ch. 16 & 17
    Slides from Lecture 19 [download]
    Slides from Lecture 20 [download]
  13. Future of DBMS & THANKSGIVING Holiday (Nov 20, 22)
    Slides from Lecture 21 [download]
  14. Class Project Demos (Nov 27, 29)--
  15. Class Project Demos & Wrapup ( Dec 4, 6)