Course Content -1. syllabus -2. lectures

1. Syllabus

Syllabus for ICS 324 for the Term 072

• ICS324-Syllabus(pdf)

Course Catalog Description

Basic database concepts. Conceptual modeling. Relational data model. Relational theory and languages. Database design. Database security and integrity. Introduction to query processing and optimization. Introduction to concurrency and recovery.

Course Objectives

To understand the basic concepts of databases, RDBMS and database theory.
To understand database design, development, and implementation
To introduce advanced topics like query processing & optimization, concurrency, and recovery.
Get an experience to work in a team environment.

Course Outline

Databases and Database Users
Database Systems Concepts and Architecture
Entity-Relationship Model
Enhanced E-R Model
Relational Model
ER and EER Mapping
Relational Algebra & Calculus
SQL
Functional Dependencies and Normalization
Practical Database Design
File Organization
Physical Database Design and Tuning
Query Processing and Optimization
Transaction Processing
Concurrency Control
Database Recovery

Grading Policy

Participation & Assignments 10%
Quizzes 10%
Major Exam 1 15%
Major Exam 2 15%
Final Exam 25%
Lab Work 25%

Important Dates

Major Exam I (Monday, March 17, 2008 at 6:10 PM)
Major Exam II (Monday, May 5, 2008 at 6:35 PM)
Final Exam (Thursday, June 12, 2008 at 7:30 AM)

Instructor

Instructor Dr. Jauhar Ali
Office: 22-129 Phone: 1243
Office Hours: SMW 8:00-8:50AM and 10:00-10:50AM
E-Mail: jauhar@kfupm.edu.sa

Textbook

Fundamentals of Database Systems, by Ramez Elmasri and Shamkant Navathe, Addison Wesley, 5th Edition, 2007.