Outline of cse3330/5330

Date

Topic

Assignment

Reading Material

Tuesday 01/19 Course organization. Introduction to databases.    
Thursday 01/21 Database system concepts and architecture   Read Chapters 1 & 2
Tuesday 01/26 Database system concepts and architecture    
Thursday 01/28 Entity-Relationship Model   Read Chapter 3 (except 3.8)
Tuesday 02/02 Entity-Relationship Model    
Thursday 02/04 Project assigned and explained    
Tuesday 02/09 Enhanced E-R Homework 1 is due Read Chapter 4 (except 4.6)
Thursday 02/11 CLASS CANCELED    
Tuesday 02/16 Relational Data Model   Read Chapter 5
Thursday 02/18 ER-to-relational mapping Project 1 is due Read Chapter 7
Tuesday 02/23 Relational Algebra   Read Sections 6.1-6.5
Thursday 02/25 Relational Algebra Homework 2 is due  
Tuesday 03/02 Help session for the midterm exam    
Thursday 03/04 Midterm Exam    
Tuesday 03/09 SQL   Read Chapter 8
Thursday 03/11 SQL Project 2 is due  
Tuesday 03/16 No class (Spring Break)    
Thursday 03/18 No class (Spring Break)    
Tuesday 03/23 SQL Homework 3 is due  
Thursday 03/25 SQL programming   Read Chapter 9
Tuesday 03/30 SQL programming    
Thursday 04/01 Records and files Project 3 is due Read Chapter 13
Tuesday 04/06 Index structures   Read Chapter 14
Thursday 04/08 Index structures Project 4 is due  
Tuesday 04/13 Functional dependencies   Read Chapter 10
Thursday 04/15 Functional dependencies Homework 4 is due  
Tuesday 04/20 Normalization    
Thursday 04/22 Database Design   Read Sections 11.1 and 11.2
Tuesday 04/27 Practical database design   Read Sections 12.1 and 12.2
Thursday 04/29 Physical database design Homework 5 is due Read Chapter 16
Tuesday 05/04 Concepts of Object databases   Read Chapter 20
Thursday 05/06 Exam preparation Project 5 is due  
Tuesday 05/11
5:30-7:30pm
Final Exam (Comprehensive)    

Last modified: 05/05/10 by Leonidas Fegaras