CS 4722: Database Design II

Semester:    Fall 2004 
Room:        2147 NH 
Time:        8:00 - 9:15 AM, TR

Course Description:

	An in-depth study of advanced database design and implementation
	concepts including transaction processing, concurrency, control techniques, 
	recovery techniques, distributed databases and client/server architecture, 
	and security and authorization.
              
	Prerequisites: CS 4721 with a grade of C or better..

Software and Tools Used to Support Class:

	Oracle9
	E-mail
	Internet Browser

Required Materials:

	Fundamentals of Database Systems. 
	Elmasri & Navathe.
	Addison Wesley.

Recommended Materials:
	TBA.

        


Topics Covered:

	Introduction
	
Practical Database Design Methodology
	
Disk Storage, Basic File Structures, and Hashing 
	
Index Structures for Files
	
Query Processing and Optimization
	
Practical database Design and Tuning
	
Transaction Processing Concepts  
	
Concurrency Control Techniques
   	
Database Recovery Techniques
   	

 
Grading Policies:
             The grades for the course will be assigned based on the following
             percentages:
             .	Tests (2-3):            			50 - 80 %
             .	Assignments & Project:				20 - 40 %			
             .	Quizzes, attendance, and class participation	 5 - 15 % 

        

Instructor:
Said C. Fares
             Office:                         2132  Nevins Hall 
             Traditional Office Hours:       10:00 AM - 11:00 AM M&W
 					     or by appointment
             Electronic Office Hours:        Any day, any time
             E-mail:                         sfares@valdosta.edu
             Phone:                          (912) 333-5780

Semester Calendar:
	August     16:	First Class Day
	September   6:	Labor Day
	October     8:	Mid-term
	November22-26:	Thanksgiving
	December    6:	Last Class Day
	December    7:  Exam Preparation Day
	December    8:  Final (Wednesday, 10:15 am - 12:15 pm) 



Last update August 11, 2004