CS 499-D: Advanced Database Concepts

Quarter:     Winter 1998 
Room:        Lab (Brookwood Plaza)
Time:        6:00 - 8:20 PM, M/W

Course Objectives:

To be familiar with the fundamentals of database design issues, and to use SQL server software.

Prerequisites:

 
	CS 499 A: Database Design and Implementation I

Software and Tools Used to Support Class:

 	Microsoft SQL Server
	ERwin

Required Materials:

	1. 	Fundamentals of Database Systems, 
		Second Edition by Ramez Elmasri and Shamkant B. 
		Navathe, The Benjamin/Cummings Publishing Company, 1994.

	2.	Microsoft SQL Server,
		Second Edition
		SAMS Publishing

Topics Covered:

 Course Outline: 
 I.	Fundamentals of DATABASE SYSTEMS
	1.	Overview of the Database Design Process

	2.	Transaction Processing Concepts

	3.	Concurrency Control Techniques

	4.	Distributed Databases and Client-Server Architecture

	5.	Recovery Techniques

	6.	Emerging Database Technologies and Applications

	7.	Database Security

II.	Microsoft SQL Server

Homework Assignments:

	The course will include a number of homework assignments.
	SQL Server and ERwin software will be used

Project:

	None

Grading Policy:

        The grades for the course will be assigned based on the 
	following percentages:
             .       Tests (2):              75-85%
             .       Assigments/Project:     15-25%

Instructor:

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

Last update January 5, 1998