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 (Jan 20, 22) -- Hoffer: Ch. 1 
    Slides from Lecture 1 [download]
    Slides from Lecture 2 [download]
  2. Database planning and Conceptual Design (Jan 27, 29)   -- 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 (Feb 3, 5)   -- Hoffer: Ch. 4 & 5 
    Slides from Lecture 5 [download]
    Slides from Lecture 6 [download]
  4. Database Design: Physical Design and Access Methods -- (Feb 10, 12)  
    Slides from Lecture 7 [download]
    Slides from Lecture 8 [download]
  5. Relational DBMS & Relational Algebra and Calculus (Feb 17, 19)  -- Hoffer: Ch. 6
    Slides from Lecture 9 [download]
    Slides from Lecture 10 [download]
  6. More on SQL and Database Applications (Feb 24, 26)   -- Hoffer: Ch. 7
    Slides from Lecture 11 [download]
    Slides from Lecture 12 [download]
  7. Database Applications: Coldfusion and PHP -- (Mar 2, 4)  
    Slides from Lecture 13 [download]
    Slides from Lecture 14 [download]
  8. Introduction to ORACLE: Database Security and Integrity(Mar 9, 11)   -- Hoffer: Ch. 8 
    Slides from Lecture 15 [download]
    Slides from Lecture 16 [download]
  9. Database Administration and Database Applications(Mar 16, 18)   --Hoffer: Ch. 9  
    Slides from Lecture 17 [download]
    Slides from Lecture 18 [download]
  10. Spring Break -- (Mar 23, 25)  
  11. Database Applications (Mar 30, Apr 1)   -- Hoffer Ch. 10 
    Slides from Lecture 19 [download]
    NOTE: April 1 Meeting TBA
  12. Object Relational Databases Features and JDBC for Java Applications (Apr 6, 8)   -- Hoffer: Ch. 12
    Slides from Lecture 20 [download]
    Slides from Lecture 21 [download]
  13. Data Warehousing and Data Mining (Apr 13, 15)   -- Hoffer: Ch: 11 
    Slides from Lecture 22 [download]
    Slides from Lecture 23 [download]
  14. Object Oriented Data Model  & Object-Relational DBMS & Applications (Apr 20, 22)   -- Hoffer: Ch. 13 & 15 & Appendix D. 
    Slides from Lecture 24 [download]
    Slides from Lecture 25 [download]
  15. Future of DBMS (Apr 27, 29)  
  16. Class Project Demos(May 4, 6)  
  17. Class Project Demos & Wrapup (May 11)