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 29, 31) -- McFadden: Ch. 1  
    Slides from Lecture 1 [download]
    Slides from Lecture 2 [download]
  2. Data Models - Relational, Network, Hierarchic, Object, Object-Relational(Sep 5, Sep 7)  -- McFadden: Ch. 2  
    Slides from Lecture 3 [download]
    Slides from Lecture 4 [download]
  3. Database planning and Conceptual Design (Sep 12, 14) -- McFadden: Ch. 3 & 4 & 
    Slides from Lecture 5 [download]
    Slides from Lecture 6 [download]
  4. Organizing Information into a Database (logical database design) (Sep 19, 21)-- McFadden: Ch. 6  
    Slides from Lecture 7 [download]
    Slides from Lecture 8 [download]
  5. Physical data organization and access methods -- Integrity Constraints(Sep 26, 28) -- McFadden: Ch. 7
    Slides from Lecture 9 [download]
    Slides from Lecture 10 [download]
  6. Relational DBMS & SQL - Relational Algebra and Calculus(Oct 3, 5) -- McFadden: Ch. 9 
    Slides from Lecture 11 [download]
    Slides from Lecture 12 [download]
  7. Database Applications (Oct 10, 12) --McFadden: Ch. 10 
    Slides from Lecture 13 [download]
    Slides from Lecture 14 [download]
  8. Database Administration (Oct 17, 19) --McFadden: Ch. 13 & 14 
    Slides from Lecture 15 [download]
    Slides from Lecture 16 [download]
    NOTE: On October 19th the class will meet in 110 South Hall instead of 202.
  9. Query and Data Manipulation Languages -- 4GLs, and More on SQL (Oct 24, 26)
    Slides from Lecture 17 [download]
    Slides from Lecture 18 [download]
  10. Data Warehousing and Data Mining (Oct 31, Nov 2) -- McFadden: Ch. 14
    Slides from Lecture 19 [download]
    Slides from Lecture 20 [download]
  11. Object Oriented Data Model and Other Database Systems (Flat, inverted files, etc.) & Object-Relational DBMS (Nov 7, 9) -- McFadden: Ch. 5, 12, Appendix A
    Slides from Lecture 21 [download]
    Slides from Lecture 22 [download]
  12. TBA--(Nov 14, 16)
  13. Object Relational Databases and Applications & THANKSGIVING Holiday (Nov 21, 23)
    Slides from Lecture 25 [download]
  14. Future of DBMS & Project Demos (Nov 28, 30)--
  15. Project Demos and Wrapup ( Dec 5, 7)