CS482 : Database Management System I
(Tentative Schedule)
(Time: Tthu 5:00pm - 6:15pm)

This page only contains power point slides. To get slides in PDF format, follow this link.

Week Date Topic Chapter Notes Assignment Due date
1 19-Aug-03 Introduction 1, 2, 3 Class 1 1.7, 1.10
  21-Aug-03     Class 2 2.11
2 26-Aug-03 Relational Data Model 2,4 Class 3 Read Ch. 3
  28-Aug-03     Class 4  
3 2-Sep-03 Relational Data Model 4 Class 5  
  4-Sep-03 Relational Data Model 4 (Cont.) Class 6 4.5,4.6,4.7
4 9-Sep-03 E-R Model 5 Class 7 Read 5.7
11-Sep-03 E-R Model(Continue) 5 Class 8 5.7 11:59 pm, Sep 17
5 16-Sep-03 Review      
  18-Sep-03 Midterm 1      
6 23-Sep-03 Relational Algebral and SQL 6 Class 9 6.9,6.10 11:59 pm, Oct 1
  25-Sep-03 RA & SQL (continue)      
7 30-Sep-03 Relational Normalization Theory 8 Class 13 8.4,8.15 11:59pm,Oct 15
  2-Oct-03 Relational Normalization (cont) SQL Homework 11:59pm, Oct 5
8 7-Oct-03 BCNF, 3NF 8   8.23,8.24 11:59pm,Oct 22
  9-Oct-03 Decomposition 8    
9 14-Oct-03 Fall break       
  16-Oct-03 4NF 8 Project
10 21-Oct-03 4NF continue      
23-Oct-03 Review (1/2 class)      
11 28-Oct-03 Midterm 2      
  30-Oct-03 Triggers and Active Database 9 Class 15 9.5 11:59pm,Nov 5
12 4-Nov-03 SQL in the real world 10 Class 16  
  6-Nov-03 Physical Data Organization and Indexing 11 Class 17  
13 11-Nov-03 Extra Test    
  13-Nov-03 Query Processing (Basics)   13 Class 18  
14 18-Nov-03 Object Databases 16 Class 19  
  20-Nov-03    
15 25-Nov-03 Database and the Web 17 Class 20  
  27-Nov-03 Thanksgiving Holiday      
16 2-Dec-03 Database and the Web (Cont.)     Proj. Explaination
  4-Dec-03 Review (1/2 class)      
17 8-Dec-03 Final Exam (3:30pm - 5:30pm)      

Last modified: Mon Dec 01 15:49:27 Mountain Standard Time 2003