SIMS 257 schedule
This is a preliminary outline for the course. It can be expected to change
during the semester.
Week. Content (dates) --
readings
-
Introduction to database concepts (
Aug 24, 26) -- Kroenke: Ch. 1 & 2
Slides from Lecture 1
Slides from Lecture 2
-
Data Models - Relational, Network, Hierarchic, Object, Object-Relational(Aug
31, Sep 2)
Slides from Lecture 3
Slides from Lecture 4
-
Levels/Views of data and database planning. (Sep
7, 9) -- Kroenke: Ch. 3 & 4
Slides from Lecture 5
Slides from Lecture 6
-
Organizing Information into a Database (logical database
design) (Sep 14, 16)--
Kroenke: Ch. 5 & 6
Slides from Lecture 7
Slides from Lecture 8
-
Physical data organization and access methods -- Integrity
Constraints(Sep 21, 23) --
Kroenke: Ch. 8, 10
Slides from Lecture 9
Slides from Lecture 10
-
Relational DBMS & SQL - Relational Algebra and Calculus(Sep
28, 30) -- Kroenke: Ch. 9
Slides from Lecture 11
Slides from Lecture 12
-
Database Administration (Oct
5, 7) --Kroenke: Ch. 14
Slides from Lecture 13
-
TBA-- (Oct 12, 13, 19)
-
Query and Data Manipulation Languages -- 4GLs, and More on
SQL (Oct 21)
Slides from Lecture 17
-
Hierarchic & Network DBMS (Oct
26, 28) --Kroenke: Ch. 16
Slides from Lecture 18
Slides from Lecture 19
-
TBA--(Nov 2, 4)
-
Object Oriented Data Model and Other Database Systems (Flat,
inverted files, etc.) (Nov 9, 11) --
Kroenke: Ch. 17
-
TBA--(Nov 16, 18)
-
New Data Models -- Extended-Relational and Object-Oriented
DBMS applications
(Nov 23)
-
Future of DBMS & Project Demos (Nov
30, Dec 2)