SIMS 257 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 24, 26) -- Kroenke: Ch. 1 & 2 
    Slides from Lecture 1
    Slides from Lecture 2
  2. Data Models - Relational, Network, Hierarchic, Object, Object-Relational(Aug 31, Sep 2)  
    Slides from Lecture 3
    Slides from Lecture 4
  3. Levels/Views of data and database planning. (Sep 7, 9) -- Kroenke: Ch. 3 & 4 
    Slides from Lecture 5
    Slides from Lecture 6
  4. Organizing Information into a Database (logical database design) (Sep 14, 16)-- Kroenke: Ch. 5 & 6 
    Slides from Lecture 7
    Slides from Lecture 8
  5. Physical data organization and access methods -- Integrity Constraints(Sep 21, 23) -- Kroenke: Ch. 8, 10
    Slides from Lecture 9
    Slides from Lecture 10
  6. Relational DBMS & SQL - Relational Algebra and Calculus(Sep 28, 30) -- Kroenke: Ch. 9 
    Slides from Lecture 11
    Slides from Lecture 12
  7. Database Administration (Oct 5, 7) --Kroenke: Ch. 14 
    Slides from Lecture 13
  8. TBA-- (Oct 12, 13, 19)
  9. Query and Data Manipulation Languages -- 4GLs, and More on SQL (Oct 21)
    Slides from Lecture 17
  10. Hierarchic & Network DBMS (Oct 26, 28) --Kroenke: Ch. 16 
    Slides from Lecture 18
    Slides from Lecture 19
  11. TBA--(Nov 2, 4)
  12. Object Oriented Data Model and Other Database Systems (Flat, inverted files, etc.) (Nov 9, 11) -- Kroenke: Ch. 17
  13. TBA--(Nov 16, 18)
  14. New Data Models -- Extended-Relational and Object-Oriented DBMS applications (Nov 23)
  15. Future of DBMS & Project Demos (Nov 30, Dec 2)