Topics Covered and Class Activities

CS 499: Database Design and Implementation I


Week  Day  DoW    Date    Ch	Topic				Homework
----  ---  ---    ----    --	----------------------		-----------
8     15   Wed    12/3          Final


7     14   Mon    12/1          Finishing up
				Review for the Final
				Survey

7     13   Wed    11/19   17&18 Introduction to			Assignment#4 is due 
			          Transaction Processing

6     12   Mon    11/17         SQL Server			Assignment#3 is Due

6     11   Wed    11/12    16   Query Optimization		Assignment#3
								Assignment#4

5     10   Mon    11/10    12   Normalization
				ERWin Lab Time

5      9   Wed    11/5          ERWin

4      8   Mon    11/3     12   Design Guidelines and 
				Functional Dependencies
				Test1  

4      7   Wed    10/29    7    SQL-A Relational Database Language

3      6   Mon    10/27    6    More about Mapping
				Relational Algebra
			   7    SQL-A Relational Database Language

3      5   Wed    10/22    6    Database Design			Assignment#2
				More about ER-Data Model
				Mapping an ER-Diagram into
				   Relations

2      4   Mon 	  10/20    4   Record Storage and 		Turning in Assignment#1 
				     Primary File Organizations 
			   5   Index Structures for Files
    

2      3   Wed    10/15    3    Data Modeling Using the		Assignment#1
				     Entity-Relationship Model
			   4    Record Storage and 
				     Primary File Organizations 

1      2   Mon    10/13    1    Databases and Database Users
			   2    Database System Concepts and Architecture
				Applying for e-mail accounts
				Check the e-mail accounts
				Lab Time

1      1   Wed    10/8          Class Introduction
           			E-mail Accounts
				Syllabus
			   1    Databases and Database Users    Reading Chapter 1

Last update November 19, 1997.