Topics Covered and Class Activities

CS 4720-A: Database Design


Week  Day  DoW    Date    Ch	Topic				Homework
----  ---  ---    ----    --	----------------------		-----------
16     31  Fri    12/11         Final at 10:15-12:15

15     30  Tue    12/8          Finishing up 
				Final Review
				Survey

15     29  Thu    12/3     7:30 am  Presentation (Hamann/Huff/Baker)
			   8:00 am  Presentation (Newlun/Cronin)
			   8:30 am  Presentation (Thompkins/Randolph/Johnson)

14     28  Tue    12/1     7:30 am  Presentation (Hamann/Huff/Baker) Moved to Thursday at 7:30
			   8:00 am  Presentation (Musgrove/Griffin)
			   8:30 am  Presentation (Lively/Blevins)

---    --  Mon    11/30         Project is due
           
14     27  Thu    11/19   23    Concurrency Control in 		
				Distributed Databases
				Presentations Schedule

13     26  Tue    11/17   23    Concurrency Control in 		Progress Reports
				Distributed Databases

13     25  Thu    11/12         Project discussion
 
12     24  Tue    11/10   18    Transaction Processing Concepts 
			  18    Time-Based Concurrency Control
			  	Going over test2

12     23  Thu    11/5    18    Transaction Processing Concepts

11     22  Tue    11/3    17    Transaction Processing Concepts	Progress Report

11     21  Thu    10/29         Test

10     20  Tue    10/27   16    Query Optimization

10     19  Thu    10/22   16    Query Optimization

9      18  Tue    10/20   12    Design Guidelines, Functional Dependencies, and 
				Normalization

9      17  Thu    10/15   12    Design Guidelines, Functional Dependencies, and 
				Normalization

8      16  Tue    10/13   7	SQL- A Relational Database Language

8      15  Thu    10/8    7     SQL- A Relational Database Language

7      14  Tue    10/6          Going over the Relational Algebra Exercises
				Progress Report is due

7      13  Thu    10/1          Project Presentations

6      12  Tue    9/29     	Project Presentations	

6      11  Thu    9/24     6    The Relational Data Model and Relational Algebra

5      10  Tue    9/22          Going over the text		Project Presentation

5      9   Thu    9/17          Test1

4      8   Tue    9/15     5 	Indexed Structures for Files
				Review for the test
				Progress Report is due

4      7   Thu    9/10     4 	Storage Devices, Blocks, Buffers, and File Organizations
			   5    Indexed Structures for Files
			        ERWin Demonstration

3      6   Tue	  9/8	   4    Storage Devices, Blocks, Buffers, and File Organizations

3      5   Thu    9/3      3	Data Modeling Using E-R Model
				Going over proposals

2      4   Tue	  9/1	   3	Data Modeling Using E-R Model
				Proposal is due

2      3   Thu    8/27     2    Database System Concepts and Architecture

1      2   Tue    8/25     1    Databases and Databases Users

1      1   Thu    8/20          Class Introduction
				Syllabus			   
                                Why studying Databases

Last update September 9, 1998.