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