CS 4721: Database Design I

Semester:    Spring 2005 
Room:        2142 NH 
Time:        10:00 am - 10:50 AM, MWF

Course Objectives:

             This course provides a thorough background in database concepts, 
             as well as practical information on database system design.

Course Description:

             The logical organization of Databases: the entity-relationship model;
             the hierarchical model, network, and relational models.
             Hardware characteristics; file organization and evaluation. Functional 
             dependencies and normal form. Query optimization, concurrency control, 
             and distributed database systems.
              
             Prerequisites: CS 3410 with a grade of "C" or better.

Software and Tools Used to Support Class:


	Oracle 
	
E-mail
	
Internet Browser

Required Materials:

             Fundamentals of DATABASE SYSTEMS,  Elmasri/Navathe.
             Addison Wesley.

Topics Covered:

	Introduction to Database System Concepts
	
Database System Concepts and Architecture. 
	
Data Modeling Using the Entity-Relationship Model. 
	
Enhanced Entity-Relationship Modeling and Object Modeling. 
	
Record Storage and Primary File Organizations. 
	
Index Structures for Files. 
	
The Relational Data Model, Constraints, and Relational Algebra. 
	
SQL-The Relational Database Standard. 
	
ER- and EER-to-Relational Mapping, and Other Relational Languages. 
	
Examples of Relational Database Management Systems: Oracle and Microsoft Access. 
	
Functional Dependencies and Normalization for Relational Databases. 
	
Relational Database Design Algorithms and Further Dependencies.
	
Practice of Database Design and Tuning. 
	
Advanced Data Models and Emerging Trends

Grading Policies:


The grades for the course will be assigned based on the following 
percentages:
	Tests (3):						70 - 85%
	
Assignments, Quizzes, Attentance, and Participation	15 - 30%

Grading Scale
        <= 90		A
        >=80 AND <90	B
        >=70 AND <80	C
        >=60 AND <70	D
        < 60		F

Instructor:

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

Spring Semester 2004 Calendar:

January 10: First Class Day January 17: MLK March 4: Mid-term March 4 - April 1: Spring Break May 2: Last Class Day May 6: Final (Friday, 8:00 am - 10:00 am)

Last update January 8, 2005